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 ,

 

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.