How identify PowerBi Report from the executing SQL?

[DavidDBA43]

How do I identify which cloud based PowerBI reports are using the SQL that is being captured on a databaese server?

We have poorly coded SQL Server SQL and are looking to correct it. How do I identify the PowerBI reports that are using it?

This would also be help when identifying the impact when table definitions need to change.

Thank You for your assistance

[GilbertQ]

Hi @DavidDBA43 

You can have SQL Profiler running, which you can store the resutls to a table in your database to then identify queries?

Save Trace Results to a Table - SQL Server Profiler | Microsoft Learn

[DavidDBA43]

GilbertQ thank you for your response

I would need to run SQL profile for several thousands of PowerBI reports. 

Is there anything in the profile trace I can add to identify which PowerBI report the SQL is from?

If there is nothing in the SQL to identify which report the SQL is for, I will need to do it at a time when no one else is running the reports on the cloud PowerBI App and manually record which report the SQL is from.

[GilbertQ]

Hi @DavidDBA43 

Yeah that makes it quite hard to troubleshoot but I do not know of any other way to do it!