How to create a live connection between a published Power BI report and Excel file on SharePoint

Hi robbert-bi 

you can set up an automatic sync between your Excel file and a SharePoint List, while continuing to use Excel for data input by syncing it with a SharePoint List:

• Open the Excel file, select the table, and export it to a SharePoint List using Excel Desktop (Export → Export Table to SharePoint List). Enter the SharePoint site URL to complete the setup.
• Use Power Automate: Sign in, create a flow, and select the "When a row is added, modified, or deleted" trigger for Excel. Choose the SharePoint-hosted Excel file and add an "Update item" action to sync data with the SharePoint List. Save and test the flow.

Now, any updates in Excel will sync automatically to the SharePoint List in real time.

If the user must keep the Excel file as the direct source, then use power automate can trigger dataset refreshes whenever changes occur.

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You!