Share this article

Latest news

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft interns leverage their creativity to develop new Power BI dashboard tool

2 min. read

Published onAugust 20, 2015

published onAugust 20, 2015

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Last month we reported onMicrosoft’s Power BI coming out preview. Microsoft’s visualization framework tool became available to the general public on July 24thas well as Power BI business analytics service. Alongside the news of general availability, Microsoft also highlighted its contributions of Power BI visualization framework and its complete library of visuals to the open source community under an MIT license.With Power BI available to the general public, a four-member team of Microsoft interns are showing what Power BI can accomplish with a little bit of time and creativity. Allison Fisher, a Microsoft intern and member of the project helped develop a real-time health dashboard that correlates SQL Azure deployments with essential performance metrics.What Allison and her team did is considered a bit of a hack, but she does offer some insight into the process.

In order to be actionable, our dashboard needed frequent refresh (every 5 minutes), and we also needed to be able to include data from different sources in the same report. We really wanted to be able to leverage the interactive slicing capabilities of Power BI in our report, which meant that we needed relationship detection to inform Power BI how to slice every element of the report together, regardless of the source.We knew that the Power BI Designer Preview provided auto-relationship detection among datasets, and we knew the Power BI REST API allowed us to push the data as frequently as we wanted. However, there was no way to marry these two capabilities with the existing Power BI product.Our tool, Post to Power BI, is a solution that allows users to join data from multiple sources and push it to PowerBI in a low-latency refresh loop.

Allison continues withmore detailed steps in the process. Their efforts help enhance Power BI hot-path data reporting tool by effectively joining data from multiple sources in a low-latency refresh loop.Not bad for a summer project done by interns.

Kareem Anderson

Networking & Security Specialist

Kareem is a journalist from the bay area, now living in Florida. His passion for technology and content creation drives are unmatched, driving him to create well-researched articles and incredible YouTube videos.

He is always on the lookout for everything new about Microsoft, focusing on making easy-to-understand content and breaking down complex topics related to networking, Azure, cloud computing, and security.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Kareem Anderson

Networking & Security Specialist

He is a journalist from the bay area, now living in Florida. He breaks down complex topics related to networking, Azure, cloud computing, and security