Connect On-Premise Report Server to SharePoint Online Cloud

[Anonymous]

Hi,

One of my client have the SharePoint EPM Online server hosted in cloud. However when it comes to Power BI reports, they would like to see the reports in another On-Premise report server. Now how to bring the SharePoint Online server data to report server On-Premise region ?

Thanks,

[d_gosbell · Accepted solution]

As listed here in the supported data sources https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

If your data is in a Sharepoint Online list your only option is to use cached data,

This means you have to manually refresh the data in Power BI Desktop and then upload the file to the Report Server. You cannot schedule refresh of Sharepoint Online data using Report Server, you would need to host your report in the cloud service if you want to do that.