Automating MS List update with underlying Excel file

Hi FeeCamp ,

According to your statement, I think you want to automaticlly refresh your report when data source is updated. 

As far as I know, we need to click on "Refresh" button to refresh the report manually in Power BI Desktop.

After you publish report to Power BI Service, we can configure schedule refresh for your dataset. Your data source is Excel, you need to install gateway for schedule refresh.

For reference: Add or remove a gateway data source

This is a good method if excel will be updated at a fixed time every day. You can set the time for schedule refresh after excel refreshing time.

Or you can upload excel to Onedrive or Sharepoint and create your report by file from Onedrive or Sharepoint.

Then you can try Onedrive refresh for your dataset. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.