how to get a list of all SQL tables used in Power BI?

[tracyhopaulson]

Hello all,

Is there a way to find out all the SQL tables that are currently used in Power BI?  Thanks

[amitchandak]

@tracyhopaulson ,

Not Pretty Sure. But see if this blog can help

https://radacad.com/get-list-of-queries-in-power-bi

[tracyhopaulson]

@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.

[mahoneypat]

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

[tracyhopaulson]

Good suggestion, but how do I get this list from the refreshes?

[v-deddai1-msft · Accepted 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

[tracyhopaulson]

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.

[mahoneypat]

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