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 practis...
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
KumarDarmesh's avatar
KumarDarmesh
Icon for Helper IV rankHelper IV
9 years ago

prerak

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

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

    • carvalhoelder's avatar
      carvalhoelder
      Icon for Advocate II rankAdvocate II
      9 years ago

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

      How can I see the full query?