cannot connect to sharepoint list

jsgrosskopf
jsgrosskopf used Ask the Experts™
on
I am trying to write a ssrs report based on a sharepoint online list. I have tried about 100 different variations of the connection string with no luck. Can anyone point me in the right direction?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Microsoft SharePoint List DataSource has the connection string on the general-tab, which needs the URL pointing to the root of your list (exclude the actual list-name, that comes later in the DataSet query designer).  On the credential-tab, you may need to enter credentials with the Use as Windows credentials checked, but try each credential options, and go back to the general-tab to click the Test Connection button.

Maybe a firewall is blocking you, ConnectionStrings website shows different combinations for SharePoint.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial