Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

nait

Exporting summarized data is not working on Power BI service

Submitted by on ‎02-01-2023 11:06 AM

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

See more ideas labeled with:
11 Comments (11 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎02-01-2023 06:01 PM
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
‎02-02-2023 05:17 AM

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

nait
Frequent Visitor
‎02-02-2023 05:24 AM

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
‎02-02-2023 02:42 PM

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
‎02-02-2023 03:17 PM

Facing a similar issue

 

Cluster Location - SouthEast Asia (Singapore)

Service version: 13.0.19958.49

 

 

 

Marit
Helper II
Helper II
‎02-02-2023 10:40 PM

I am facing the same issue as well. 

Powerbi_User109
Regular Visitor
‎02-02-2023 11:03 PM

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

Powerbi_User109_0-1675407722390.png

 

nait
Frequent Visitor
‎02-03-2023 05:47 AM

It worked! Thank you! 

I did not realize we had to change anything there.

 

nait_0-1675431788763.png

 

KolheNilesh
New Member
‎02-06-2023 07:10 AM

@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
‎02-06-2023 01:59 PM

Thank you for the information! I understand.

Idea Statuses