If you use an Excel file as a source in Power BI, it is usually connected locally. Now you cannot update the source without a gateway. With the following steps you can easily replace an existing local Excel file with the cloud version. You don’t have to recreate the Power BI report or reconnect the source!
- Upload the Excel file to Microsoft OneDrive is a file hosting service from Microsoft. From our point of view the best cloud storage on the market! Here you can find helpful tips and help with Microsoft OneDrive: OneDrive help and tips You can find the official Microsoft help page here: https://support.microsoft.com/de-de/onedrive or SharePoint is a shared access platform on which team members can upload files and edit them together. Official Microsoft SharePoint website and call up the path via Excel.
2. Do the following in Power BI