Get your Application Insights data in Power BI – Faster than ever

Get your Application Insights data in Power BI – Faster than ever

Power BI has the ability to bring the data from multiple sources and represent in a rich visual way.  You can customize and filters the data coming from different data sources and do the visual representation of data which matter most to your end users.  To visualize the Application Insights data in Power BI, One of the approach we have used so far this process is using  Continuous Export and Azure Stream Analytics.  While this process works very well, and using Azure Stream Analytics, you can transform the Application Insights data to any other data sources, but this takes sometime to configure and setup.  But so far that is the best option where you can have your own custom quires in places to get resultant data.

With the help of Application Insights Content Pack for power BI, you can also get the basic set of just following couple of steps.

image.png

 

Step 1 :   Open the Content Pack Library

Open the Power BI Portal, from the left bottom corner of the menu bar, select “Get Data” and then select “Get” from the Services section under “Content Pack Library

image.png

Once you select the “Get” button from the in previous steps, it will navigate list of Services Content Packs. There you will find option for “Application Insights”. Select the same, and then click on “Connect” from the dialog window as show in the screen shot below.

 

image.png

 

 

 

 

 

 

 

 

Step 2 :  Connecting with Application Insights

Connect to Application Insights dialog window will ask for Application Insights name, resource name and subscription Id, which you can easily get from Azure Portal.

image

Click on the next, and the sign in Authentication window will perform the authentication against your subscriptions, where you may required to provide your credentials.

image

Step 2 :  Visualize the Application Insights Data in Power BI

That’s it. It may take a while to configure your data sets and other records, but soon your dashboard would be ready with report as shown below.

image.png

 

To get a granular level of details,, you can click on individual items. Which will take a you to more lower level of details.

image.png

You can customize this report, or if wish to have your own, you can create them from the Data Sets.

image.png

For automatic updates you can configure the Datasets settings.

image

 

Read more about the Application Insight Content Pack here   Explore your Application Insights data with Power BI

Hope this helps !

Abhijit Jana

Abhijit runs the Daily .NET Tips. He started this site with a vision to have a single knowledge base of .NET tips and tricks and share post that can quickly help any developers . He is a Former Microsoft ASP.NET MVP, CodeProject MVP, Mentor, Speaker, Author, Technology Evangelist and presently working as a .NET Consultant. He blogs at http://abhijitjana.net , you can follow him @AbhijitJana . He is the author of book Kinect for Windows SDK Programming Guide.