Forum Discussion

JillHenninger's avatar
JillHenninger
Icon for Helper I rankHelper I
5 years ago

SharePoint Authentication Issues

Hi all I have a dataset that refreshes nightly and taps into 6 SharePoint based Excelf files and one OData (connected to a SharePoint list). Way more often than not, the dataset won't refresh due to...
Need Help
AlonaOnline's avatar
AlonaOnline
Frequent Visitor
4 years ago

I found a solution by adding a correct URL to the Sharepoint document - Open the Document in the Desktop Ap -> Information -> Copy path ( I am not sure about wording, since I am using a German Version) You need to copy only a part of the path, for me it looks like https://companyxy.sharepoint.com/sites/XXX/ 

and when you connect the source you need to make sure that no Gateway is selected and your authentification is set to organisation