Forum Discussion

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago

Export pbix file to excel/csv

Hi,   I have the report data in pbix file (say some 20 columns in one table)   I need to export that data in excel/CSV .  Is there any easy way to do it? I understand it can be done manually...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi GuestUser 

 

Why don't you use excel to connect to the data source, you can google it for detail it is fairly simply. 
If you really want the data from pbix, there are only two ways.

1. As you mentioned, manually copy paste the entire table or export date to excel or CSV 

2. Using the pbix local port number from PBI Desktop temp directory for connecting Power BI Desktop Model from Excel.

For the steps, you could refer to the links below: 

http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax...

http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-bi...

Best, 
Paul

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.