Direct Query - Synanpse Query Tracking/Monitoring

[Anonymous]

Hi , Is there a way we can track SQL query fired by Power BI which is built on Direct Query Mode in Synapse ? 

Is it possible to tag a label for queries to genereated by Power BI?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

First find the port number of the related .pbix file via below:

https://www.biinsight.com/four-different-ways-to-find-your-power-bi-desktop-local-port-number/

Then connect to sql profiler with the port number to trace queries.See below:

https://insightsquest.com/2017/05/07/profiler-trace-for-power-bi-desktop/

In sql profiler,there're existing tags for the queries in Power Bi.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thanks for Checking. Running the belwo query on the Data warehouse will give the recently sent Power BI querries to the DW. 

SELECT
request_id,
session_id,
status,
convert(date, submit_time) submit_date,
submit_time as submit_datetime,
convert(varchar(8), convert(time, submit_time)) as [submit_time],
convert(varchar(8), convert(time, start_time)) as [start_time],
--start_time,
end_compile_time,
convert(varchar(8), convert(time, end_time)) as [end_time],
--end_time,
total_elapsed_time,
[label],
error_id,
database_id,
command,
resource_class,
importance,
group_name
classifier_name,
resource_allocation_percentage,
result_cache_hit
FROM sys.dm_pdw_exec_requests
where command like '%$table%'
Order by submit_datetime desc