Direct Query Synapse

[jdbmwl]

I have a model with a table that is direct query, and the backend database is Synapse.  When I apply filters to get a result set in PBI, I can see the wheel running as it's querying the data.  However, when I go into Synapse and look at Query Monitor, I don't see the query at all.  

This is running from my desktop, I'm just confused as to why I don't see the query and can't figure it out.

[maruthisp · Accepted solution]

Hi jdbmwl,
Can you try to follow below links to debug and identify what is happening in Synapse?
If you are using - Serverless SQL Pool:
https://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics
If you are using - Dedicated SQL Pool
https://docs.azure.cn/en-us/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics
SELECT
request_id, status, command, start_time, total_elapsed_time
FROM
sys.dm_pdw_exec_requests
WHERE
login_name = 'YourPowerBIUser'
If you are using connecting through a Gateway or using Azure Analysis Services / Power BI Service:
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

Please go through the above links. 

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[maruthisp · Accepted solution]

Hi jdbmwl,
Can you try to follow below links to debug and identify what is happening in Synapse?
If you are using - Serverless SQL Pool:
https://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics
If you are using - Dedicated SQL Pool
https://docs.azure.cn/en-us/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics
SELECT
request_id, status, command, start_time, total_elapsed_time
FROM
sys.dm_pdw_exec_requests
WHERE
login_name = 'YourPowerBIUser'
If you are using connecting through a Gateway or using Azure Analysis Services / Power BI Service:
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

Please go through the above links. 

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[jdbmwl]

I am using a Dedicated SQL Pool, that link sent me to a not found page BTW, however, the query you posted showed me what I was looking for.  I'm still researching why I can see the query in that list, but the Dedicated SQL Pool monitor through Azure does not show those requests.

Appreciate the info!

[maruthisp · Accepted solution]

Hi jdbmwl,

I am sorry as the above links were not working. I updated the links in the original post. Please go through. Thanks in advance.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X