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…