Forum Discussion
On premise server refreshing excel document from sharepoint online
Unfortunately you cannot do this. Sharepoint Online is documented here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn as not supporting scheduled refresh. Your options are to either host your report on the Power BI service or use some other process to bring the files into a location that PBIRS can use for a scheduled refresh (such as a local network share)
Super UserUnfortunately you cannot do this. Sharepoint Online is documented here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn as not supporting scheduled refresh. Your options are to either host your report on the Power BI service or use some other process to bring the files into a location that PBIRS can use for a scheduled refresh (such as a local network share)