Issue with summarized export

[Marit]

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

[v-tangjie-msft]

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. 

[Marit]

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

[v-tangjie-msft]

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. 

[Marit]

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.