Use sharepoint Online list as datasource in ssrs report (on prem)

Question

Hi

I'm trying to create a datasource in a report based on a sharepoint online List. I saw a couple of post about this but nothing works.

Example of post - https://social.technet.microsoft.com/Forums/en-US/a9309d7e-2d6f-499c-a1df-28fde56fe6f4/use-sharepoint-online-list-as-datasource-in-ssrs-report?forum=sqlreportingservices

I always get one of theses errors

• An error occured when accessing the sharepoint list. The Connection String might not be valid...
• Server was unable to process the request - Access denied

I tried every combination of authentification method.

My connection String is in this format : https://myaccount.sharepoint.com/sites/mysite/

Is there something to setup on the sharepoint site to make it work ?

I tried both in report builder and Visual Studio 2019
SSRS runs on SQL server 2019

Thanks

Answer 1

I'm fairly certain this won't work due to the required use of Windows authentication for connectivity to the list. Since SPO doesn't support Windows authentication (i.e. NTLM or Kerberos), this won't succeed -- in addition, the connector wouldn't support OAuth regardless, so you wouldn't be able to bypass Modern Authentication in the service.

The suggestion would be to move to Power BI which does have this capability.

Answer 2

@Hugues Veillette

Agree with trevor.

You could refer following articles to print Power BI reports.

Printing from the Power BI service
Export reports to PDF from Power BI
Workaround for printing Power BI reports

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.