cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Connect On-Premise Report Server to SharePoint Online Cloud

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,

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Connect On-Premise Report Server to SharePoint Online Cloud

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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors