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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.