- What we do
- Who we work with
- Who we are
Want to push data directly to the cloud using the Power BI API but not sure where to start? Our handy guide will help you get the basics under your belt.
Power BI can connect to a wide variety of systems to collect data to drive reports and dashboards. But what if we want to consolidate data from multiple locations, such as a large number of dynamically created SharePoint lists, into a single dataset?
You might be tempted to first consolidate this data into a location such as Azure SQL, before connecting to that SQL database from Power BI. However, this isn’t actually necessary, as we can use Power BI’s own API to create a dataset into which we can push data directly, removing the need for a separate database.
This blog post outlines the steps involved in using the Power BI API to manage data. These are:
Our Lync server caused us months of pain. So we took it out to a yard and smashed it up.
Watching the video above, you might be left scratching your head. What would drive the mild-mannered employees of a successful IT business to commit an act of wanton destruction against an innocent server?
Look again. That server is anything but innocent. It’s the Sangoma Lync Express, and we hate it.
If you’ve ever tried to set up and use your own Lync server for voice communications, you might be nodding your head rather than scratching it. The destruction was a moment of pure catharsis – the purging of two years of pent-up frustration at an infuriating piece of technology that caused our business hours of pain and grief and cost.
How did it all start? What happened to let it get this far? And did it really catch fire? (No.)
Continue reading this post »
In this blog post, we’ll help you dip your toes into the world of Power BI. If this piques your interest, don’t miss our Power BI Breakfast Briefing in Edinburgh on 19 April, where you can get a full introduction to this powerful business app in person.
One of the coolest and most powerful data visualisations available in Microsoft Power BI is the Scatter Chart. In this walkthrough, I’m going to show you how you use this chart type to bring together a very complex set of data in a beautifully clear and intuitive visual. Along the way, I’ll also illustrate a few useful tricks for data modelling in Power BI. I’m going to do all of this in the Power BI Desktop app, but it could be done in the web interface just as easily.
Continue reading this post »
Here you’ll find insight on CompanyNet’s work, what’s happening in enterprise software, and the future of the workplace. It’s written by a variety of CompanyNet staff. If you’d like to talk to us about anything you see here, just drop us a line.
Microsoft Cloud Future thinking Collective intelligence Office 365 Intranets Business intelligence Digital Transformation Office Business Transformation Technical (9) Gold Partner 20th Anniversary Change Management CRM Privacy Microsoft Inspire Partners Director's Briefing Websites Public Sector Training
On Wednesday 11th October, don't miss our next event, Breakfast Briefing – What’s next for Office 365?