Hi all, I have several reports using files from Sharepoint as a data source. I used to have Organizational account setup for authentication, which worked perfectly for a long time.All of a sudden, this authentication stopped working when I tried to import a new Sharepoint file. I've tried removing the authentication settings as suggested in other posts. This unfortunately destroyed all Sharepoint connections I had setup which means none of them are working now.As soon as I try to authenticate through Organizational, Basic or Microsoft Account, the prompt gives a "We couldn't authenticate with the credentials provided" error.I've tried several things so far but nothing seems to work.I can access the Sharepoint site without issues with the same credentials, so that doesn't seem to be the issue. Source = Excel.Workbook(Web.Contents("https://Contoso.sharepoint.com/sites/Innovation/Shared%20documents/General/Datasets/" & #"CustomerName" & "/hours.xlsx"), null, true),

Hi, My issue was different from the one described in the post you link.Appartently it was an issue with the Edge authentication prompt. I fixed the issue by changing my default browser to chrome and in Power BI go to Settings > Security > User my default webbrowser.This fixed the issue.

Sharepoint authentication error "We couldn't authenticate with the credentials provided"

Forum Discussion

17 Replies

Related content