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 us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

kjeld3shape

BUG: Power BI dataset values are not displayed as values in Excel when analyzing in Excel

Submitted by on ‎06-11-2020 04:36 AM

I have a published dataset in Power BI where there are numeric values which can be used for sums. However when I press "Analyze in Excel" the Pivot in Excel does not show them as numeric, and they cannot be used for sums.

See screen shot below where the dataset is shown in Power BI (web) and in Excel

PowerBI 2020-06-11 132928.png

 

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎06-12-2020 12:33 AM

@kjeld3shape 

 

You may take a good look at Requirements and Can't drag anything to the PivotTable Values area (no measures).

kjeld3shape
New Member
‎06-12-2020 12:57 AM

The measures are defined in the Power BI datamodel, so according to https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel... they should also be available in Excel. However they are not.

kjeld3shape
New Member
‎06-23-2020 02:28 AM

@v-chuncz-msft - any ideas how to solve the issue given the fact, that I have defined he measures in the Power BI datamodel?

llamaparty
New Member
‎01-02-2023 11:36 PM

@kjeld3shape I am having the same issue in 2023.  Did you find a resolution to your problem?

Idea Statuses