Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
Is there a way to find out all the SQL tables that are currently used in Power BI? Thanks
Solved! Go to Solution.
Hi @tracyhopaulson ,
You can use SQL Server Profiler to view query send to sql server from Power BI to find out tables used in report.
Create a trigger in sql server profiler and refreshing data in power bi desktop :
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
Not Pretty Sure. But see if this blog can help
https://radacad.com/get-list-of-queries-in-power-bi
@amitchandak Not really! I have a few hundreds of Power BI reports and would like to know which SQL tables are being used for them. The only way I know is to open every single report to get the table information, which is time consuming and not very efficient. If you or anyone have better suggestions, please share. Thank you in advance for your help.
It might be easier if you generate a file that has all the queries going to the server from all the refreshes and then parse out the table names from FROM part of all the queries.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Good suggestion, but how do I get this list from the refreshes?
Hi @tracyhopaulson ,
You can use SQL Server Profiler to view query send to sql server from Power BI to find out tables used in report.
Create a trigger in sql server profiler and refreshing data in power bi desktop :
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
Hi Dedmon, thank you so much for the information. I will share with our I.T. person for further assistance and let you know if we run into issues or have more questions.
I am not a DBA but assume there is a way the DBA (you?) could monitor the incoming queries to the database. There is not an easy way to do it w/ Power BI. I have never done it but it may be possible to extract the queries from each pbix file (they are basically zip files).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |