Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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