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: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
See more ideas labeled with:
11 Comments (11 New)
Comments
Anonymous
Not applicable
‎02-01-2023 06:01 PM

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