Forum Discussion

Tasos's avatar
Tasos
Icon for Helper II rankHelper II
8 years ago
Solved

Export whole table in Excel

Hello,   I am trying to export a whole table (as I see it in Data view) into an Excel file. Is there a direct way or I need to "create" the same table as an output in the Report view?   Thank you...
Show and Tell
Tips and Tricks
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Tasos,

 

There are some ways to export Power BI Desktop data in Excel.

 

1.You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for small volume of data. 

 

Go to Date View and select the table you want to export, select Copy Table and then paste it in Excel.

 

 

2.You need to find Power BI Desktop local port number from Power BI Desktop temp directory. Then connect to Power BI Desktop Model from Excel.

 

For the detail 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-studio-methods/

 

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

 

Please note that if you have millions of rows of data in your Power BI Desktop then you’ll be able to load 1,048,576 rows which is maximum number of rows limitation on Excel.

 

Best Regards,

Cherry

Tasos's avatar
Tasos
Icon for Helper II rankHelper II
8 years ago

Hello v-piga-msft,

 

Thank you very much for your help. I guess it was way easier than I could had thought (and to make it even worse, I had searched for something like that).