Power BI Report Server with Share point Online data source

[Karthik_Ram]

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. 

[Anonymous]

Hello! I'm facing the same issue. I understand that is not supported but I'm looking for a way to work around, for example using some power automate flows to download lists to the intranet and then using it to feed power b.i... 

Any more ideas?

[d_gosbell · Accepted solution]

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.

[Chuka]

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]

---

@Chuka 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.

[Chuka]

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.