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.
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.
Hi, great post! I was thinking, would it be possible to repurpose this report to monitoring AAS instead, as it’s basically the same behind the scenes right? Only problem I think is that the Log Analytics data is coming from two other tables (instead of the PowerBIDatasetsWorkspace table), namely the AzureDiagnostics and AzureMetrics tables. I tried connecting the pbit to our Log Analytics workspace collecting AAS diagnostics data and change the parameter ‘Log Analytics Table’ to include also the AzureDiagnostics and Azure Metrics tables as optional values and choosing AzureDiagnostics. But unfortunately this didn’t seem to work. I would be curious what it would take to make this work 🙂
Hi Robin,
Thanks for the kind words. In order to make this work I would think you would need to have a log analytics query which you would import into your PBIX and then use that to then get the data you need?
Thanks for this..how can I include the report page name. I have a report that has several pages that I need to get the usage on, thanks
Hi Jacodia,
Currently the log analytics will only look at the entire report and not at each report page.
Hi Gilbert, thanks a lot for your amazing article.
I’ve succeded to add the Report Name by using the Power BI API (Beta) connector.
When i refresh the report from Power BI Desktop, the refreh works perfectly.
But, when I publish the report to a premium workspace in Power BI Service, the Dataset refresh returns me the following error message :
Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn’t have the extension enabled. Details: Static analysis failed in gateway. gatewayObjectId:4287e316-c4b2-43eb-b38e-476b9ab0887f, resultCode:FailedWithUnknownFunctions Query contains unknown function name: PowerBIRESTAPI.Navigation Unknown function name: PowerBIRESTAPI.Navigation is a valid Mashup library function name format. Hence fail the operation. .
Do have a clue to solve this issue ?
Thank you in adavance.
Hi Adlen,
You will need to add the custom connector to your data gateway for this to workhttps://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors. Here is the link: