Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Exporting summarized data is not working on Power BI service

I have been using exporting summarized data option for years with no issues but it stopped working all of a sudden.

All I see is "Column1" and no data is included. How can I fix it? Thank you.

error.png

Status: Needs Info

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Needs Info

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

Powerbi_User109
Regular Visitor

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

nait
Frequent Visitor

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

 

 

cgmihaescu
Regular Visitor

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

Matt_Crosby
New Member

Facing a similar issue

 

Cluster Location - SouthEast Asia (Singapore)

Service version: 13.0.19958.49

 

 

 

Marit
Helper II

I am facing the same issue as well. 

Powerbi_User109
Regular Visitor

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

Powerbi_User109_0-1675407722390.png

 

nait
Frequent Visitor

It worked! Thank you! 

I did not realize we had to change anything there.

 

nait_0-1675431788763.png

 

KolheNilesh
New Member

@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=Ho....

KolheNilesh_2-1675696112710.png

Open the exported file and click on Enable Editing

KolheNilesh_0-1675695886643.png

then click Enable Load

KolheNilesh_1-1675695923578.png

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.

nait
Frequent Visitor

Thank you for the information! I understand.