cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tasos Helper II
Helper II

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,

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Export whole table in Excel

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.

 

Untitled.png

 

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...

 

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

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Export whole table in Excel

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.

 

Untitled.png

 

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...

 

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

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Tasos Helper II
Helper II

Re: Export whole table in Excel

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).

 

 

sotoc Advocate I
Advocate I

Re: Export whole table in Excel

 

 

 

EduSurveys Advocate I
Advocate I

Re: Export whole table in Excel

Hello @v-piga-msft

 

I do not see this option to "Copy table" when I perform the steps you suggested. Is this because I am using an ODBC connection to a database?

 

I tried copying the table in Power Query, but I only get the first 1000 rows.

 

Thanks. 

Frede Helper I
Helper I

Re: Export whole table in Excel

It could be worth mentioning that the Copy Table option respects whatever filter you have applied to the table in the data view, so that can be used to reduce the amount of data that is exported.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors