cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
prerak Frequent Visitor
Frequent Visitor

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

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
prerak Frequent Visitor
Frequent Visitor

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

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
4 REPLIES 4

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

@prerak

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

prerak Frequent Visitor
Frequent Visitor

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

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
Moderator v-yuezhe-msft
Moderator

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

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
carvalhoelder Frequent Visitor
Frequent Visitor

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

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

How can I see the full query?