Forum Discussion

Steel 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

Copper Contributor

luvsql did you find a solution to this problem ?

I'm trying to connect to sharepoint online but can't find the right connection string format

I tried https://mysharepoint.sharepoint.com/sites/SPsiteName

olafhelper

Bronze Contributor

Feb 02, 2021

Hello hveillette ,

Try it with the connection string from

https://www.connectionstrings.com/sharepoint/

Olaf

luvsql
Steel Contributor
Feb 02, 2021
olafhelper We cannot pass individual passwords in the connection strings. It should work with Windows Authentication so passwords are not stored in the connections.
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
  Steel 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
    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.