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 knew that I could get this using Azure Log Analytics. Not only could I find out how many users are using Excel, but I could also find out what queries they are running, how long they took.
Read on for the first part in this series, which details setting up Azure Log Analytics.