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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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