Extract datasources from a PBI File

[Robert14358]

Is there anyway to get a file extract from a PBI file that shows all the datasources used in that file?

for example if im using the customer table and the sales table, when i extract that list from somewhere, it should say these 2 tables.

[v-tejrama]

Hi @Robert14358 ,
Thanks for reaching out to the Microsoft fabric community forum.

Absolutely, you can totally get a list of all the data sources and tables in a Power BI file without having to open every single query. I’ve had clients ask about this too like if their report pulls a Customer table from Excel and a Sales table from SQL Server, they just want a quick way to see what’s connected.

The simplest way is to use Query Dependencies in Power BI Desktop. Just hit Transform Data, then go to View and select Query Dependencies. You’ll see a visual map of how everything links together and where the data’s coming from. Hover over each source to check if it’s Excel, SQL Server, SharePoint, or something else.

If you want to look deeper, DAX Studio lets you see all the tables in the model though it won’t show the original source. For detailed stuff like connection strings or source paths, tools like Tabular Editor, ALM Toolkit, or pbi-tools are super handy.

Thank you.

[v-tejrama]

Hi @Robert14358 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-tejrama]

Hi @Robert14358 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Thank you.

[v-tejrama]

Hi @Robert14358 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[alish_b · Accepted solution]

Hi @Robert14358 ,

You should be able to get this information from DAX Studio. Just connect to your report model and run one of the following queries as per your requirement:
1.   SELECT * FROM $SYSTEM.TMSCHEMA_TABLES
To get the names of all tables as they appear in the report and other general info related to them (such as Hidden, ModifiedTime, etc.)
2. SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS
This should give you the tables along with the source query and other detailed information.

Hope it helps!

[danextian]

In Desktop, you can use the Performance Analyzer to get the DAX query being used by a visual which should show the measures and the columns being used as well as their source table. Other than this, you'll have to be in Edit mode and inspect what columns are being used. Of course, these options are not avaible to the end users of your reports.