How to see Relational SQL generated by Power Bi Report.

[RG007]

Hi,

when ever  I create a report using SQL Server or Oracle or any other database in direct query Mode, then how can I see what is the SQL/Query generated and send to database by Power bi/my report.

I don't have access on database level to see the sql it ran.

also how to see what is SQL genereted in case of import mode.

Thanks

[amitchandak]

@RG007 , there is an old discussion on the same- refer this -https://community.powerbi.com/t5/Desktop/Check-generated-SQL-query/td-p/156494

Also video from guyinacube- if that can help -https://www.youtube.com/watch?v=eVDIHG4dflM

[RG007]

My question is different, I don't want to see query of a table, I want to see query for visual I have created on report  page....Thanks

[v-lili6-msft]

hi @RG007 

To see the query when you open/interact/refresh a direct query report, you need to use SQL Server Profiler tool to get it.

see more details as below:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#determining-the-que...

Regards,

Lin

[RG007]

this way I get DAX query, but I wanted to see corresponding relational query, that would have generated , if it was live connection, that query received by database.

[v-lili6-msft]

hi  @RG007 

There is a SQL query in it too.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#understanding-the-f...

Regards,

Lin

[HotChilli]

In Power Query , you can right-click the Steps of the query and choose View Native Query.