Forum Discussion

pineappleuser's avatar
pineappleuser
Copper Contributor
Jan 28, 2019

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 successful doing this with our on premise sharepoint but not with our sharepoint online lists. I have not been able to find any good documentation on how this is done. Can anyone share if this is possible and how to create it? 

SharePoint Online

2 Replies

  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Jan 28, 2019
    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
    • pineappleuser's avatar
      pineappleuser
      Copper Contributor
      Jan 28, 2019

      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. 

Resources