I have a Power BI report that sources from an Excel file on my laptop. The visualizations are in Import / Scheduled Refresh mode (to be clear, not DirectQuery / Live Connection mode). I am using the gateway in 'On-premises data gateway (personal mode)' to refresh my dataset in the service. To my surprise, after refreshing the dataset, the corresponding charts in the report do not update automatically. They only update after I click on 'Refresh' in the report itself. This goes against the claim that the reports should be updated automatically, as documented here:
https://docs.microsoft.com/en-us/power-bi/refresh-data
How can I make the report update automatically after a dataset refresh? Requiring my consumers to manually click on 'Refresh' is unacceptable.