Forum Discussion

kaguilarq's avatar
kaguilarq
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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