Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SharePoint data - We couldn't authenticate with the credentials provided. please try again

Dear All,   I have a report running that's updating on a weekly base, this report is already running for like a half year now, never have any issues. But today I get the error: "We couldn't authent...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi v-yingjl ,

     

    Thank you for your reply, I tried your steps and unfortunately, it didn't solve my issue. Finally I checked the new data set manually and I found some #N/A in it. Somehow this showed an error in PowerQuery which resulted in this error... Still strange because this error isn't referring to an error in the data set so that's confusing. 

    But when I removed the #N/A's and refreshed the report again it worked, without any credential errors.

    Kind Regards,
    Ramon

Nataliea's avatar
Nataliea
New Member
2 years ago

I tried all the suggested Microsoft Solutions and eventually found the answer on a reddit post.

 

Go to the file in SharePoint and right click on it. Select “open in app” then go to to… File>info> copy path.

When you paste the path remove the “?web=1” from the end.

The issue is that if you copy link to the spreadsheet in SharePoint the default url will prompt it to open the spreadsheet in office online and the authentication won't work but if you copy the link from the native application and remove the ?web=1 it authenticates from the app

  • CBLightning's avatar
    CBLightning
    Advocate I
    2 years ago

    This worked!! Thanks heaps! 🙂