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 OneDriveMicrosoft 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 SharePointSharePoint 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.
Get the path of the Excel file
2. Do the following in Power BI
In Power BI choose Transform Data 
Show the formula bar 
Change File.Contents to Web.Contents and paste the copied path 
Log in to access the cloud file
