How to view the queries being made by Power BI to Azure SQL warehouse

[prerak]

Task:

So I'm trying to speed up my queries on Power BI due to a large dataset.

Facts:

My power BI is connected with Azure SQL Data Warehouse 

Already tried:

I've done the standard practise of making non clustered indexes on 

Need:

When I was using a Redshift connector, I could view the queries in the Redshift AWS console.

But when I query the Azure Query console, it doesn't appear to be queries coming out of Power BI.
I'm hoping understanding the queries shall help me devise the architecture of my Table relationships in a better way.

[KumarDarmesh]

@prerak

Use DirectQuery option to connect to Azure warehouse, it imporves performance.

[prerak · Accepted solution]

I'm already using DirectQuery.

I need to be able to view the the queries being made. Nevertheless, I found it out by this query in Azure Data warehouse

select * from sys.dm_pdw_exec_requests

[v-yuezhe-msft]

Hi @prerak,

Glad to hear that you have resolved your issue. You can accept your reply as solution, that way, other community members could benefit from your solution.

Thanks,
Lydia Zhang

[carvalhoelder]

Problem is that sys.dm_pdw_exec_requests does not give the full query...

How can I see the full query?