Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Connection between dataflow and Sharepoint : credentials rejected

Dear all,

I have a couple of dataflows connected to Sharepoint using my own credentials (email + password). I recently modified my password and forgot to make the same modification in dataflows, resulting naturally in refresh failures. The problem is that I can't modify my credentials anymore. 

Dataflows now manage to get access to the target folder but can't open excel files on it :

 

SharePoint.Files("https://xxxxxxxxx.com/sites/folder/", [ApiVersion = 15])  ====> success
step2{[Name = "xxxxxxxxx.xlsx", #"Folder Path" = "https://xxxxxxxxx.com/sites/folder/subfolder/"]}[Content] =====> failure


The obtained error is :
The credentials provided for the SharePoint source are invalid. 
 
But modifying the connection doesn't solve the issue.
 
Note that when I ask someone else to open the dataflow and modify the connection (using their own credentials) the dataflow succeeds in viewing data and even refreshes successfully. But as soon as I open it again the error happens. We don't seem to have a way to modify the connection permanently.

Thanks in advance for your help,
 
Zoubeyr
Dataflow

2 Replies