ive noticed then when exporting underlying data, the excel files only contains totals.
the "solution" to this is moving all calcutions from this Measure Table to the fact table.
its hasnt always been the case. and by moving these measure im also "killing" all power bi and excel reports using this data as its no longer 'Table1'[Measure1] but 'Table2'[Measure1].
this was an issue back in 2019
Export underlying data returning only totals row.
Hi @SimonNoer ,
As you saw in the previous post, this is a known limitation and not a bug.
If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Community Support Team _ Caitlyn