Forum Discussion
Report does not refresh on schedule
Hi, Anonymous
If your dataset contains not only Sharepoint data source but also the premise data source, then it is necessary to use an on-premise gateway and configure schedule refresh. For further information, please refer On-premise data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-alq-msft
The Sharepoint that has the Excel file isn't on-premise. The file refreshes with no error or problem with Power BI Desktop. That was the first thing I checked and as noted, the more experienced developers here tried several solutions. They are stymied and think the issue likely the Power BI is online.
I was curious if anyone else had the same issue and any ideas on what to check we hadn't thought about.