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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.