failed to save modifications to the server Error returned: OLE DB or ODBC Error: Permission Error

[mkrapez]

Help Please,

I have combined multiple excel files together in powerquery and now im having trouble trying to apply them so it shows up on the desktop, it takes almost an hour to apply query and loads all the rows 2150, but it never finishes and gives me this error.

I have read and edit permission to the root url where I am taking the files from. Could It be something else I am doing wrong?

failed to save modifications to the server Error returned : OLE DB or ODBC Error: Permission Error The credentials provided for the Sharepoint source are invalid. please update them etc. 

[v-jiascu-msft · Accepted solution]

Hi @mkrapez,

Did you update your credential recently? Please try to update the credentials anyway. You can delete it and then add it back.

Best Regards,

Dale