https://community.fabric.microsoft.com/t5/Report-Server/On-premise-server-refreshing-excel-document-from-sharepoint/m-p/3747514#M33403 <P>Unfortunately you cannot do this. Sharepoint Online is documented here&nbsp;<A href="https://learn.microsoft.com/en-us/power-bi/report-server/data-sources" target="_blank">Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn</A> 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)</P> Thu, 07 Mar 2024 02:31:50 GMT d_gosbell 2024-03-07T02:31:50Z https://community.fabric.microsoft.com/t5/Report-Server/On-premise-server-refreshing-excel-document-from-sharepoint/m-p/3747330#M33401 <P>we have a PBI report built on prem</P><P>it has 2 excel spreadsheets as data sources from our sharepoint site -cloud</P><P>connections work ok from the client, but we are unable to do scheduled refresh</P><P>how to achieve this?</P> Thu, 07 Mar 2024 00:41:51 GMT https://community.fabric.microsoft.com/t5/Report-Server/On-premise-server-refreshing-excel-document-from-sharepoint/m-p/3747330#M33401 Anonymous 2024-03-07T00:41:51Z https://community.fabric.microsoft.com/t5/Report-Server/On-premise-server-refreshing-excel-document-from-sharepoint/m-p/3747514#M33403 <P>Unfortunately you cannot do this. Sharepoint Online is documented here&nbsp;<A href="https://learn.microsoft.com/en-us/power-bi/report-server/data-sources" target="_blank">Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn</A> 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)</P> Thu, 07 Mar 2024 02:31:50 GMT https://community.fabric.microsoft.com/t5/Report-Server/On-premise-server-refreshing-excel-document-from-sharepoint/m-p/3747514#M33403 d_gosbell 2024-03-07T02:31:50Z