Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
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
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
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.
Hi @DavidDBA43
Yeah that makes it quite hard to troubleshoot but I do not know of any other way to do it!
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 8 | |
| 8 | |
| 8 |