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
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?