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...
kaguilarq Every time I have ever tried to get data into Power BI from an open Excel file it fails. Perhaps you could create a Power Automate workflow that periodically copies the file and use the copy as the data source