Forum Discussion

Robert14358's avatar
Robert14358
Resolver III
1 year ago
Solved

Extract datasources from a PBI File

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 fr...
Need Help
  • alish_b's avatar
    alish_b
    1 year ago

    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!

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

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's avatar
v-tejrama
Community Support
1 year ago

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's avatar
    v-tejrama
    Community Support
    1 year ago

    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's avatar
      v-tejrama
      Community Support
      1 year ago

      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.