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.
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?
Thank you for your insights.
Best regards,
Solved! Go to Solution.
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:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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,
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:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |