Copy Table from the Table View is not working

[ashnaanil]

I frequently use the "Copy Table" feature and copy the raw data from PowerBI to Excel, but since yesterday when I right click and select copy table nothing is being copied. Is anyone else facing the same issue?

[AlexInMed]

The best solution for me was to use the Power BI platform instead of PowerBI desktop: 

1. Navigate to your workspace
2. Open the Sematic Model (instead of the Report) 
3. Select the table on the right panel 
4. Finally click the EXPORT button

[gvlado]

For one table I got message "Export failed" - is it because of size ( it is 500 000 rows)

[Syndicate_Admin]

Hi everyone, I would like to know how to enable the option to export data from a visual. I have an array and it comes out: "The Export Data function is not available for this visual", I hope for your help.

[v-jialongy-msft]

Hi @all

In the new PowerBI Desktop version released on March 29th, the copy table feature is available.

Best Regards,

Jayleny

[gvlado]

Where can we find it  - relase March 2024 (March 29.)

[FH_MEL]

Hi all,

While we wait for a resolution, you can download previous versions of PowerBI here: 

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

*Note: The Feb 2024 update is mistakenly labeled as December 2023.

May the odds be ever in your favor!

[EMP]

Same issue here... 

[Anonymous]

Hi, same situation here, definitely it's not working anymore this feature on version 2.127.1080.0 64-bit (March 2024) 😔 I hope they fix it asap

[v-jialongy-msft · Accepted solution]

Hi @all

This issue has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Jayleny

[FH_MEL]

@v-jialongy-msft, Hoping for a resolution to the full "copy table" function will be available soon. There seems to be a limited workaround, but unfortunately, it does not completely remedy the issue.  Thank you in advance!

[Anonymous]

Hi, 

The Copy Table option is not working in table view.

alternatly you can copy the table.

go to the new dax query view in the new updated version, just below the model view.

there write a small query "evaluate(table_name) and run.

the mentioned table will populate and there will be a copy icon, where you can copy the whole table and paste in excel or where ever you work on.

 if it works, accept it as solution.

Thank you!

[gvlado]

[FH_MEL]

@Anonymous How can I remove the limit of 15MB or 10,101 rows and change the format of the column headings? Thank you in advance!

[JamieRRose]

How do you increase the Limit of Max 15Mb or 100,000 values what ever come first.

[UW-DA]

I am having the same issue. Yesterday I was able to copy a table with no issues and I know yesterday I had February 2024 version. Today I am unable to copy a table and I'm on the March 2024 version. Version: 2.127.1080.0 64-bit (March 2024)

[Luli_Guzman]

I have the same issue with copying tables from Power BI to Excel (version of Power BI: March 2024

[v-jialongy-msft]

Hi @ashnaanil 

The version I am using now 2.126.927.0 64-bit (February 2024) works fine, if you can, please provide the version number you are using or update to the latest version.

Best Regards,

Jayleny

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

[tharaka]

Version: 2.127.1080.0 64-bit (March 2024), I think is the latest?

Does not work "copy table", unable to copy several million rows