Stuck with "Working on it" message while exporting data from Power bi desktop to MS Excel.

[Max00713]

[Max00713]

Thank you for your response. It was a case of a larger dataset.

However, I tried filtering the columns and selecting only a few lines to check whether the export option was working. I could see that my data was filtered in the Table view, but when I tried using the copy table option, the full dataset was copied, regardless of the filtering.

[v-ssriganesh · Accepted solution]

Hi @Max00713,
Thanks for the update.

I understand that you see the filtered data in Table View within Power BI Desktop. However, please note that filtering in Table View only affects how data is displayed it does not modify the underlying data model, which is why the full dataset is still being copied when using the Copy Table option.

Instead of using Copy Table, try using "Export Data" on a visual. To do this, create a table or matrix visual in your report, apply the necessary filters, then right-click on the visual and select "Export Data." This ensures that only the filtered rows are exported.

I trust this information proves useful. If it does, kindly Accept it as a solution and give it a 'Kudos' to help others locate it easily.
Thank you.

[v-ssriganesh]

Hi @Max00713,
Thank you for reaching out to the Microsoft Fabric Forum Community.

The "Working on it" message while exporting data from Power BI Desktop to Excel usually indicates that Power BI is taking longer than expected to process the export. Here are some steps you can try to resolve this issue:

• If your dataset is large, Power BI may struggle to export it. Try filtering the data to export a smaller subset.

• Close Power BI, restart your computer, and try exporting again.

• Instead of Excel, try exporting as a CSV file to see if it works.

• Check you're using the latest version of Power BI Desktop. You can download updates from the following link: Download Power BI | Microsoft Power Platform

• If Power BI is using too much memory, try closing other applications before exporting.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[Idrissshatila]

Hello @Max00713 ,

it's either you're trying to export a huge amount of data or there's some sort of a bug.

try getting the power bi latest version or you can open an issue in the issues section and Microsoft support will check it https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues