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.

Summary

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.