Forum Discussion
Accessing Sharepoint Online Data with SRSS
I am using visual studio to try and create a data connection to our sharepoint online lists so that we can run some sql reporting services reports off of the sharepoint online list data. We are succe...
Well, SPO authentication is completely different to SP OnPremises and additionally out of your OnPremises deployment...migth I ask what version of SSRS you have? Instead of using RSS, you should use OData Connection...but I doubt it's going to work
well that stinks :) We are using SQL 2017, we have also tried OData connection and it isn't working either. We have some third party software called datasync that can connect but I will have to move it to a table on a schedule and it won't be on demand like I want it to be.