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 OneDrive or SharePoint and call up the path via Excel.
2. Do the following in Power BI