cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stharwani Regular Visitor
Regular Visitor

Values from measures not available in Excel

HI team,

 

I am connecting to Power BI dataset from Excel using the Excel Publisher.

I am not not able to see values for some measures in the Pivot table in Excel, while those measures work absolutely fine in Power BI.

 

Anyone else faicng the same problem? Any solutions?

 

Thanks.

5 REPLIES 5
v-yulgu-msft Super Contributor
Super Contributor

Re: Values from measures not available in Excel

Hi @Stharwani,

 

Were you unable to see all measures in Pivot table or just some specific measures? If just for some one, what are those measures look like?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
eborella Frequent Visitor
Frequent Visitor

Re: Values from measures not available in Excel

Hi

 

It seems there was no followup on this topic but I ran onto the exact same issue.

 

I'd like to display in an Excel pivot table those 2 measures values coming from the connected Power BI dataset:

 

1- SUM([timeoriginalestimate])/3600

2- CALCULATE(sum('jira_tempo_Worklog'[hours]),(1.0*(today()-'jira_tempo_Worklog'[workdate])<8),jira_tempo_Worklog[username] <> "admin")

 

Measure #1 does display values, but measure #2 does not.

 

Any ideay why?

 

Thanks

Stharwani Regular Visitor
Regular Visitor

Re: Values from measures not available in Excel

That could possibly be the issue with measure. Try breaking the measure down by individual Filter and see if that works. 

 

My issue was different, the Excel connector wasnt stable, so I re-installed and older version and it worked. 

eborella Frequent Visitor
Frequent Visitor

Re: Values from measures not available in Excel

Indeed, the issue was in the measure itself. The data model was imported from Power Pivot and all the measures are working fine, but by looking into it I realised this calculate measure with multiple filters doesn't work. So the issue is not related the Excel connexion.

 

Thanks

Highlighted
PhuTriNguyen Occasional Visitor
Occasional Visitor

Re: Values from measures not available in Excel

This is a big problem in Excel when connecting to SSAS Tab model that measures are not available in Excel.  The workaround is to create calcuated measures then they are available in Power BI and Excel.  However, the aggregation is fixed when you create the measure (like SUM, AVG) and you cannot change it in Excel or Power BI.  It seems like there is no update from MS on this issue.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 134 members 1,757 guests
Please welcome our newest community members: