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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
wpf_
Post Prodigy
Post Prodigy

How can I update the analyze in excel file to use the updated measure?

So i have a power bi file that i uploaded to the service.  I downloaded the analyze in excel file on my computer and it works fine.  However, I made a change to one of the measures, so the analyze in excel is still showing data with the old measure.  How can I update the analyze in excel file to use the latest measure without me having to download a new analyze in excel file and rebuilding the pivot table?  Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @wpf_ 

  You dont need to downlod the new excel file for this. You can refresh the excel from Data Ribbon and hit Refresh button. Also, you can control how & when the data should be refreshed.

 

rajendran_0-1634661787497.png

 

Thanks
Raj

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @wpf_ 

  You dont need to downlod the new excel file for this. You can refresh the excel from Data Ribbon and hit Refresh button. Also, you can control how & when the data should be refreshed.

 

rajendran_0-1634661787497.png

 

Thanks
Raj

@Anonymous Thanks you are right.  A refresh would have worked.  I forgot that I published the pbix file to two different workspaces, and the excel pivot file was connecting to the one that I did not update.  I just did and refreshed and it works now. Thanks. 

@Anonymous 

Refresh does not use the updated measure.  It's still showing me the old data from the old measure.  

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

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

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors