PBI Desktop crashes when exporting data from table visual

[Vinnie]

Hi all,

Since the last couple of weeks, we have been experiencing Power BI Desktop crashes when exporting data from table visuals. Is anyone else experiencing this problem? We are not getting any error. Power BI desktop just crashes and restarts (if lucky).

Vincent

[ravsaint]

does anybody know how long this willl be open issue for MS ? 
i have w newest build, - 2 weeks and no solution 

[hnguy71]

Hi @Vinnie and @ravsaint 

Since it's already reported by many people I'm sure it's likely they'll have it fixed by next monthly roll-out. It isn't high enough priority to upload a hotfix version just for this.

There are many alternative solutions floating around that can be achieved to export the data

[ravsaint]

but the problem is - i don't see this issue in the bucket with known issues that they are working on it ... 
Looks like they don't have priority to this, more I will to say ... then don't have knownledge how it is problematic (exp.:  for me - i don't have privilages in my system for rollback. So... it is really a driver for looking for new tool with wide reporting tools , sources.)

Simply: Power Bi now is the problem 

[Vinnie]

Looks like the same issue as reported by several other users here:

https://community.fabric.microsoft.com/t5/Desktop/Export-Data-from-Power-BI-to-csv-does-not-work/m-p...

[Vinnie]

Hope anyone can help how to raise this as bug?

[powerbidev123]

Hi @Vinnie , what is the size of your dataset

[Vinnie]

Hi @powerbidev123 , that would be about 14.000 rows. Do you also need the number of columns?

[Anonymous]

Hi @Vinnie ,

According to the official document, if your table only 14k rows should not trigger the limitations of export features. How many columns your table included?

Export data from a Power BI visualization - Power BI | Microsoft Learn

In addition, have you checked the idel memory resource that the device included?
If currently existed too many backend processing and they spend huge amount of system resource may cause not enough resource for export operation usages.

Regards,

Xiaoxin Sheng

[Vinnie]

Hi @Anonymous , thank you for your reply. The table that I am exporting is about 14k rows and 41 columns.

My device (laptop) has 16GB of RAM. The memory usage of Power BI does not seem to exceed this limit with all the other programs that are running. Also, this is what SWAP memory is for right? That is enabled on my system.

[Anonymous]

HI @Vinnie,

What version for power bi desktop are you worked on ? If that not a recently version, have you tried to update it to the last versions and try again with these operations?

In addition, table with too many fields may affect the performance. Have you tied to reduce the column fields in query edit and try to export again?

Regards,

Xiaoxin Sheng

[Vinnie]

Hi @Anonymous  , thx for all the help!

I am using the very latest version from the Microsoft Store:

It happens to two of my tables, doesn't happen to the others and is not always reproduceable. When retrying a few times, it sometimes doesn't crash. Crashes most of the time though.

Since SWAP memory is there if you run out of memory, this looks like a bug in PBI Desktop?

[Anonymous]

HI @Vinnie,

In fact, I'd like to suggest you download version power bi desktop. The store version normally update quicker than download versions and they may release some small update that cause the hot issues.

Download Microsoft Power BI Desktop from Official Microsoft Download Center
Regards,

Xiaoxin Sheng

[Vinnie]

Hi @Anonymous , I reverted back to the 2024 March version and it works fine now. No more issues. This definitely looks like a bug which occurs in the last few versions of PBI Desktop. How can I raise this bug with Microsoft?