Forum Discussion
Helper IIPower BI Report Server with Share point Online data source
Hello,
We have a Power BI Report which uses Sharepoint List as datasource. When i connect from Power BI Desktop everything works fine. But when i publish and go to manage in Power BI RS I am not able to create a successful connection. Neither Anonymous or Windows option works.
Unfortunately this is a product limitation. Power BI RS does not have the ability to authenticate against Sharepoint Online lists. It's listed in this documentation as not being a supported data source for scheduled refresh.
5 Replies
- d_gosbell
Super User
Unfortunately this is a product limitation. Power BI RS does not have the ability to authenticate against Sharepoint Online lists. It's listed in this documentation as not being a supported data source for scheduled refresh.
- d_gosbell
Anonymous wrote:
The linked documentation shows that it is supported, unless it wasnt as at the time this post was made.
Even though it is, it still hasnt worked for me any updates.
So I just double checked to see if this had changed and the following screenshot of the above documentation link from today 20 July 2021 and it still shows unsupported for Sharepoint Online.
Like I mentioned the issue is the authentication. Report Server does not currently support any sources that require OAuth and this is a requirement for most cloud based data sources. Your only option for Report Server is to use some other tool like a PowerShell script or some other ETL tool to pull the data from Sharepoint Online and put it somewhere local like a SQL database or CSV file which Report Server does support scheduled refresh.
