DAX to SQL Query

[Anonymous]

Hi,

Is there any way to convert a Power Bi DAX query to a SQL query fast - like an online tool/converter?

[isaac-m]

Hi -- Have you ever gotte an aswer on this.  I Really Really need assistance here.  Thnx

[v-gizhi-msft]

Hi,

You can use SQL Server Profiler to capture the SQL query when refreshing data on Power BI Desktop.

Reference:

https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-v... 

Best Regards,

Giotto Zhi

[TomMartens]

Hey @Anonymous ,

basically, there is no such tool. But maybe you can try this, create a direct query connection , and trace the query using SQL Server Profiler or DAX Studio: https://www.sqlbi.com/articles/analyze-directquery-requests-using-dax-studio/

Regards,

Tom