Connection String for Sharepoint Online

jsgrosskopf
jsgrosskopf used Ask the Experts™
on
I need to create a report based on a sharepoint online list. When our sharepoint server was in house, this was not a problem but I cannot get the connection string to work for sharepoint online. I do not know power BI and frankly don't have time to learn it. If I can get SSRS to connect and I can get my report done in 1/2 hour. Anyone know the connection string to make this work?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
The string should be the same as you mention. Make sure you are connected to the site. They may be why it is not working.

Good luck...
jsgrosskopfIS Manager

Author

Commented:
I ended up getting a 3rd party odbc driver to connect to sharepoint. Thanks anyway for help.
jsgrosskopfIS Manager

Author

Commented:
Found
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Glad you found the answer. Have a good one!

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