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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Marit
Helper II
Helper II

Issue with summarized export

Hi!

 

When I try to export summarized data form power bi service the data is not summarized in the excel file. Even though the report i set to not allowing export of underlying data! Why is this happening? I don't think this was problem with this report before, and I don't know about any changes that should have any impact.

 

Regrads Marit

 

 

4 REPLIES 4
v-tangjie-msft
Community Support
Community Support

Hi @Marit ,

 

Are you exporting data from a table visual? Is there an error message?

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Yes, I am exporting from visual. No error message. I am geting an excel file with the underlying data.

Hi @Marit ,

 

Please try using a measure or calculated column to create a tabular visual that actually aggregates the values, and then export the current layout.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

I am allready using a measure that is aggregated on date level at the x axis. But when I try to export data on the month level, the data is still exported on day level. I am sure it was not like this before.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors