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!

alish_b's avatar
alish_b
Super User
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!