Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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.
Thanks
Raj
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.
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.