cannot connect to sharepoint list

jsgrosskopf used Ask the Experts™
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?
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