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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DataNinja777
Super User
Super User

Power BI data refresh from Excel data source when the file is open

Hi Power BI Community,

 

Previously, I was able to refresh Power BI data from Excel data source even when the Excel file is open, but recently I am getting a message like below, and I cannot refresh pbix file when the source Excel file is open.  This behavior is similar to Excel Power Pivot resfresh, which requires the source Excel file is closed in order to refresh the data.  Has anything been changed recently regarding the ability of Power BI to refresh from Excel source data when the Excel file is open?  

DataNinja777_0-1716425755842.png

Thank you for your insights. 

Best regards,

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @DataNinja777 

The real surprise here is that it worked for you before :).

I've been using the tool since 2017 and the refresh only works when the file is closed.

I'm attaching links to some very old discussions on the subject:

https://www.myonlinetraininghub.com/excel-forum/power-query/power-bi-refresh-from-open-excel-workboo...

https://community.fabric.microsoft.com/t5/Desktop/How-to-refresh-dataset-from-an-opening-Excel-file/...

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
DataNinja777
Super User
Super User

Thank you @Ritaf1983 .  I've used Power BI in multiple workplaces since 2017, and Power BI data when the source Excel file was open could always be refreshed until a few days ago, and I regarded this as one of many advantages of Power BI over Excel Power Pivot.  Thank you for letting me know about an alternative experience. 

Best regards,

Ritaf1983
Super User
Super User

Hi @DataNinja777 

The real surprise here is that it worked for you before :).

I've been using the tool since 2017 and the refresh only works when the file is closed.

I'm attaching links to some very old discussions on the subject:

https://www.myonlinetraininghub.com/excel-forum/power-query/power-bi-refresh-from-open-excel-workboo...

https://community.fabric.microsoft.com/t5/Desktop/How-to-refresh-dataset-from-an-opening-Excel-file/...

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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