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: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

0

Exporting underlying data calculation in measure table

Submitted by Anonymous on ‎03-27-2023 03:57 AM

Hello

 

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. 

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎03-28-2023 08:21 PM

Hi @Anonymous ,

 

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.

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses