Wondering "how Microsoft does IT” with regard to the cloud? Don’t miss this IT Showcase course! Gain insights into how Microsoft is moving to the cloud to support its 180,000 internal users. Learn the best practices Microsoft has created and employed to design, develop, deploy, and operate in the cloud for our global environment.

This online course combines presentations and demonstrations in an on-demand setting and covers various topics, including architecture, planning, operations, maintenance, and support of the cloud in the Microsoft global environment.

Watch in-depth presentations from the subject matter experts who design, deploy, manage, and support the Microsoft journey to the cloud. Wrap up the course with multiple best practices and approaches to cloud adoption to use in your own environments to improve operations and business results.

Plus, learn how Microsoft develops its strategies to expose and embed cloud business processes and to drive business success.

  • Understand how Microsoft moved to the cloud.
  • Get an overview of Microsoft IT, the IT Showcase team, and the Microsoft IT journey to the cloud.
  • Get a history of the cloud at Microsoft, cloud service delivery models, strategy, and value prop.
  • Learn how Microsoft IT identified stakeholders and assessed cloud readiness.
  • Explore the Microsoft approach to moving from a hybrid cloud strategy to a public cloud strategy.
  • See how Microsoft IT uses the different Azure feature sets.
  • Take a closer look at the BC Web engineering case study.
  • Learn about Connect @ Microsoft.
  • Hear about the Social Experience Platform (SxP), built from the ground up in the cloud.
  • Get the details about MS Approvals, which delivers a modern app experience with minimal effort.
  • Find out about the Business Travel Letter case study and its associated risk assessment.
  • Hear from Azure VM how Microsoft IT is using IaaS.
  • Find out how Microsoft IT tracks cloud consumption.
  • Hear about the Microsoft Exchange migration to Office 365.
  • Explore the phases Microsoft IT used in deploying Office 365 to employees.
  • Hear about the Microsoft IT migration to SharePoint Online.
  • Explore the Microsoft IT approach to running Microsoft Dynamics within the company.
  • Learn about the Microsoft IT approach to security.
  • Find out how Microsoft IT readies employees for the technology changes that are deployed.
  • Listen to a recording of Microsoft IT cloud SMEs answering customers' questions.


In some previous posts I explained what is Azure Application Insight Analytics, and in this post I will show you how you can create Power BI dashboard using Azure Application Insights Analytics data.

So to start, you should login to the Azure Portal and navigate to your Application Insight resource there which will look like below:

Then you click on the Analytics menu to go to the Kusto page to write your Kusto query that you want to generate a Power BI report out of it:

After you wrote your query, click on the "Export" and select the "Power BI Query" menu:

Then it downloads a .txt file for you which contains the Power BI query that you have written in Kusto window which will look like below:

This is all we need from Azure Application Insight side. Now it is time to move it to Power BI.

Import Application Insights data to Power BI

First of all you need to download the "Power BI desktop" application using the below URL:


Then you open the application and click on the "Get Data" menu from the top ribbon and from the list select the "Blank Query" option:

Then you click the Advanced Editor menu from the top ribbon:

And you will see the Advanced Editor dialog open where you should copy and paste the content of the Power BI query you downloaded (the content of the .txt) to that window and click "Done".

Now you should be able to see the result of the query execution and the query name (maybe you want to rename the query to be something other than "Query1" to be more meaningful when you come back to it later on).

Now you are almost done, you can click on "Close & Apply" from the top left corner and you can start to build your report:

From the very right column you can select the columns you want in your report as well as the visualization type to make the report look meaningful and readable.

All done, now you can click on "Publish" from the top of the page where you will have to save your Power Bi file (.pbix) and then publish your dataset/report to your Power BI account.