Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cebyweiman
Frequent Visitor

excel files connected to power bi dataset do not show new measures added

Hi All, 

 

We use the Analyze in Excel functionality all the time in our business and one problem keeps coming up: When I add a new measure to a Dataset/Semantic model the new measure doesn't show up when using an excel file that had been previously connected to that dataset. The user has to make a new connection and rebuild their pivots if they want to use the new measure. 


Has anyone else encountered this, and is there a workaround/fix besides having to rebuild something in excel every time a new measure is added and you want to use it?

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

Hi @cebyweiman 

 

The issue you're experiencing is a known limitation when using the "Analyze in Excel" feature in Power BI. When a new measure is added to a Power BI dataset, Excel doesn't automatically update to include this new measure in existing pivot tables or pivot charts. This is because the pivot table's cache doesn't refresh in the same way as it does within Power BI Service.

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
cebyweiman
Frequent Visitor

Thanks Jayleny - much appreciated!

v-jialongy-msft
Community Support
Community Support

Hi @cebyweiman 

 

The issue you're experiencing is a known limitation when using the "Analyze in Excel" feature in Power BI. When a new measure is added to a Power BI dataset, Excel doesn't automatically update to include this new measure in existing pivot tables or pivot charts. This is because the pivot table's cache doesn't refresh in the same way as it does within Power BI Service.

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.