Forum Discussion
Get data from an open Excel file
Hello team, Looking for your help on this. I have a shared Excel file online. This file needs to be opened 24/7, since it will be edited by people in different time zones. Power BI Desktop i...
Based on the tests I've just done, Power BI refreshes the data fine when the file is open and only relying on auto save.
Why do you need to close the file for the refresh to work? Are you getting errors when the file is open?