Forum Discussion

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

Copper Contributor

Feb 02, 2021

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

luvsql
Iron Contributor
Feb 02, 2021
hveillette As with many Microsoft Services that don't work as documented, I give up and move on. Sad really.
olafhelper
Bronze Contributor
Feb 02, 2021
Hello hveillette ,

Try it with the connection string from
https://www.connectionstrings.com/sharepoint/

Olaf
- 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
    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.
- luvsql
  Iron 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.