Part 2 – Storing the Log Analytics Queries in Azure Blob Storage (Power BI Query Usage and Performance Series)
Following on in my series, in this blog post I am going to demonstrate how to store Log Analytics Queries in Blob Storage. This allows me to be able to store the Power BI Queries externally from Log Analytics and to have an easy way to get the data into my Fabric Lake house in later steps. To do this…
Power BI Query Usage and Performance Series – Part 1 – Enabling Log Analytics, generating the KQL queries
As with most of my blog posts it involves a client from a customer where I am consulting, which I think will help others. The requirement was to analyse the Power BI Query usage patterns of the users. The initial requirement was to find out how many users were using Excel to gain access to the Power BI Dataset. I…
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…
Logging (Datasets, users & query performance) – Part 6 – Migration AAS to PPU
Another important aspect when having datasets is being able to log and monitor performance. In this blog post I am going to compare the logging between Azure Analysis Services (AAS) and Power BI Premium Per User (PPU). With the recent release of PPU having integration with Log Analytics it makes it a lot easier to compare the logging options between…