How to find the SQL generated by PowerBI

[gpsankaran]

Hi Team

Is there a way to find the SQL of the Power BI visuals which is created using multiple queries (tables). It will be useful to validate between Power BI and Backend Database. 

We have option to get the DAX query of the visuals but not SQL.  In order to validate the data most of the time the developers are forced to write the SQL using the queries used and join them and run in the backend database. There is a high chance making mistakes here particulary when we apply many transformations in Power Query.  The Native Query option may give only the SQL of one particular query which may not be useful to validate the visuals.

I believe it will be difficult to get the SQL because once the Queries are loaded and PowerBI Engine will be doing transformation and other stuffs using the DAX language.

However in SAP BO we have option of getting the SQL generated by BO and which can be directly run in the backend database.

[vanessafvg · Accepted solution]

are you using direct query?

I am sure you can use sql server profiler to trace the queries.

if not if you install dax studio that will probably give you a flavour but it wont be the same.    using performance anazlyer in the desktop you can grab the queries and run in dax studio and see what it generates.