Forum Discussion
Helper IIPower BI Report Server with Share point Online data source
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.
Super UserUnfortunately 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.
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.
- 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.
Thanks a lot, I was actually refering to SharePoint On-Prem (my mistake 😁).
Please could you possibly guide me how to setup a working SharePoint On-Prem connection string for PBiRS.