The SQL query of the report

[Anonymous]

Hello Community,

I need to check the SQL query generated by report.

do you have any idea where can i find this option ? i'm using import data by the way (not direct query)

Thanks in advance

[Anonymous]

@Anonymous,

 This article should have the information you need

[Anonymous]

Hello,

Thanks for your answer.

Currenlty, im looking for the the query generated by the report. When i develop report i want to see the query behind the report.

Thanks,

Med

[AkhilAshok]

The report generates DAX queries and NOT SQL queries behind visuals if it is created as Import. If you want to see the DAX queries which are getting generated and easy way is to connect DAX Studio to the Power BI report and start tracing the queries.

[v-lili6-msft]

hi, @Anonymous 

If you want to see the query behind the report, you need to get it in Edit Queries(Power query)

Then apply it into data model of power bi, and no you could develop the report based on the data model, not the query.

Best Regards,

Lin

[rmh]

How can I get the Report in Edit Queries(Power query)?