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!

danextian's avatar
danextian
Super User
1 year ago

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.