How to turn on SSAS profiler traces in Power BI desktop

Just a quick post today. Power BI desktop has a feature to turn on the SSAS profile traces that allows you to see all the queries (DAX and SQL in DirectQuery mode) generated by the reports. I couldn’t find any documentation to turn it on so let’s take you through the steps here.

I start with a very simple PBI desktop file that points to a SQL Azure Database in Direct Query mode:

Read more...