Exporting summarized data is not working on Power BI service

Hi nait ,

I can reproduce your problem and in order to better help with this fix, we need to gather a bit of information.
1.Your PBI cluster location
2.Your PBI Service version 

Thanks in advance, I will post the issue to the internal ICM platform as soon as I receive a response.

Best regards.
Community Support Team_ Caitlyn

I am also finding the same issue . Please help with some solution .

Thank you for your comment

1. Your PBI cluster location - We use WABI-SOUTH-EAST-ASIA
2.Your PBI Service version - not sure how to find it

Hi. I am experiencing the exact same issue as nait for reports that haven't been modified for a while, this export option suddenly stopped working. First time we noticed was on Jan 25th.

Cluster  - WABI-UK-SOUTH-B-PRIMARY

Service version - 13.0.19958.49

Let me know if there's any updates, looks like a bug

Facing a similar issue

Cluster Location - SouthEast Asia (Singapore)

Service version: 13.0.19958.49

I am facing the same issue as well. 

Try selecting option : .xlsx (Excel 150,0000- rowmax) . it should work

It worked! Thank you! 

I did not realize we had to change anything there.

nait: Power BI has recently (mid-January 2023) launched a feature of exporting data using live connected Excel files.

https://powerbi.microsoft.com/en-cy/blog/announcing-connected-excel-tables-from-power-bi/#:~:text=How%20do%20I%20export%20live,Export%20data%20from%20the%20menu.

Open the exported file and click on Enable Editing

then click Enable Load

After this, data will be loaded. As it is a live connected Excel file, it will create an Excel connection and load the data on Enable Load option.

Hopefully, this is helpful.

Thank you for the information! I understand.