Export list of tables present in my data modal

[Bhavana_PB]

Hi Everyone,

I have .pbix file and  to make various reports there are more than 30+ tables present in my .pbix file , and it is a live connection to client's data, but  now he has sent this updated .pbix file, saying some tables have been updated and some new are added into my data modal of new .pbix file.

What I want to do, is that I want to export the list of tables along with columns present in those table directly from my .pbix file, as I cannot make out what exact tables or columns have been updated in my new .pbix file.

Is this possible in Power BI? Can do the export  on data modal ?

Thank you
Bhavana

[v-qiuyu-msft · Accepted solution]

Hi @Bhavana_PB,

There are two methods: 

1. Create table visuals in the report, drag each table columns to separate table visual, then export data from table visuals. See: https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data

2. Go to report Data tab, right click on the table, choose Copy Table then paste it in Excel file. 

Best Regards,
Qiuyun Yu 

[campagnol54]

Hello,

You may have a look at this project where you can compare two pbix files and export your model:

https://github.com/didierterrien/Power-BI-assistant

Best regards