cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 ACCEPTED SOLUTION
d_gosbell
Super User II
Super User II

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.

View solution in original post

1 REPLY 1
d_gosbell
Super User II
Super User II

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!