How I added my Report Names to the Log Analytics Report
I was really excited to use the Power BI Log Analytics for Analysis Services Engine report when it was released along with this blog post from the Power BI Team: Announcing long-term usage and performance insights (Public Preview) | Microsoft Power BI Blog | Microsoft Power BI
This is really a great report when using Log Analytics.
I found the one thing that I wanted to view was my report names. The standard report did not have this.
In this blog post I will show you how I went about getting the report name, as shown below this is what it defaults to
And this is what it looked like after I made some changes, read below to find out what I did to get this working.
Loading data into the report
The first thing that I did was to download the Power BI Log Analytics for Analysis Services Engine.pbit and put in the required parameters and load the data.
Next, I went to Power Query Editor and opened the table called “Operation”, in here I saw that there was a column called “ReportId” as shown below
I made sure to save my PBIX file, as there is nothing worse than forgetting to save!
This got me thinking (Imagine my head smoking!), and I then remembered that the amazing Miguel Escobar had created a Power BI REST API Connector
I was really excited; I think I was onto something.
Loading the Power BI REST API Connector
I then went and downloaded the .mez file
I followed the steps to get it copied to the right location, which I did by copying it to following location: C:\Users\UserName\Documents\Power BI Desktop\Custom Connectors
Next, I had to close my PBIX (after already saving the PBIX) and open it again. This is to allow it to look for any Custom Connectors.
Then I had to go into Options and settings, then Options
I then clicked on Security, and under Data Extensions changed it to be (Not Recommended).
I then clicked Ok.
Now to connect to use the Custom Connector I clicked on Get Data, then more to open the Get data Window. I then search for “Power BI API”
I then clicked on “Power BI API (Beta) and clicked Connect
I got the Preview Connector window, I clicked on the “Don’t warn me again for this connector” and clicked Continue
I was then prompted to log in with my Organizational account
Once signed in I then clicked on Connect
In the Navigator window, I expanded Workspaces and clicked on Reports. I could then see that I had the “Report ID”. This was the magic link!
I clicked on Transform Data
Now in Power Query Editor I merge my reports table with the Operational table.
I then expanded the table and selected the columns I needed from the Report table.
I then clicked Ok.
Followed by Close and Apply to load the data into the dataset
I could then see the dataset and Report Name as shown below.
This then allowed me to create the Report page, which I had shown at the start of my blog post.
In this blog post I have shown how to use a Custom data connector to get the additional data I needed to get the report name.
I could then create a report with additional insights.
Thanks for reading and if there are any comments or suggestions please let me know.