Forum Discussion

prerak's avatar
prerak
Icon for Advocate I rankAdvocate I
9 years ago
Solved

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.

 

Need Help
  • prerak's avatar
    prerak
    9 years ago

    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

    • prerak's avatar
      prerak
      Icon for Advocate I rankAdvocate I
      9 years ago

      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
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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