Forum Discussion

luvsql's avatar
luvsql
Iron Contributor
Oct 01, 2020

Unable to access SharePoint List in SSRS Report Builder

After choosing the Microsoft SharePoint List as the connection type in my data source, entering the correct URL for our SP Site, going to Credentials and setting to prompt (as there is no option for ...
hveillette's avatar
hveillette
Copper Contributor
Feb 02, 2021

olafhelper Thanks for the hit but i Guess that Cdata is a paid third party.

Theses connections string seems to be used with this component.

 

I'm trying to use the Sharepoint list datasource option in Report builder or visual studio 2019 (SSRS) but nothing works

  • luvsql's avatar
    luvsql
    Iron Contributor
    Feb 02, 2021

    hveillette I think it's "by design" so customers are forced to pay $$$$ to get Power BI for all users.

    • JonathanSdavey's avatar
      JonathanSdavey
      Copper Contributor
      Mar 03, 2021
      Come on really. Here we are 20 years on and Im still using access to generate Reports from Sharepoint List that contains multiple attachements (photo's) that I want in my simple 1 page Report/Record.

Resources