Refresh failed - Status code 400

[DarshanGandhi]

Hi,

My existing dashboards refresh is failed and it showing error even after trying to make sure that credentials were correct.
I tried, many times, entering credentials, but its not taking it (please note credentials are correct).

Its showing STATUS CODE: 400

Not sure what is wrong here. Is anyone facing same issue?

[v-qiuyu-msft · Accepted solution]

Hi @DarshanGandhi,

From the image, it seems that you use web data source connect to SharePoint online file, right? If it is, please use the OAuth2 authentication instead of the Basic.

Best Regards,
Qiuyun Yu

[nniphadk]

Your comment helped with my problem.

[Anonymous]

Hi,

Could you plesae help me with the same issue. I am not able to see Oauth as an option for my problem. Really need your help to resolve this issue.

[chocy]

hey faizannaeem,

It was fixed very simply, I realised the ones with x next to them are the ones that are failing and need to have credetials updated. As i had been trying to update the credtials on the ones that didnt have x's next to them thinking they were the ones that needed to be fix. once i realised this i was able to update the credentials on them all and it was fixed.

[tobiasmoehrke]

Hi, I used the OAuth2 authentication but I still get the status code 400. What is weird is that it works for some sources and for others it does NOT(all in the same sharepoint/onedrive folder)! Please help. I cannot set up a planned update for my datamodel.

Cheers

Tobias

[chocy]

i have the exact same issue. did you end up getting this resolved?

[SabaM]

Hello,

I have almost the same issue, tried to change Authentication method but in the list only 1 option is available

"WindowsWithoutimpersonation"

I'm taking excel files from dropbox and want to set up a scheduled updates but due to aforementioned credential error not able to get updates

[DarshanGandhi]

Hi Qiuyun Yu,

Yes it indeed worked out.

Thanks for your help.

Regards.

DG

[v-qiuyu-msft]

Hi @DarshanGandhi,

Glad to hear the issue is gone

Best Regards,
Qiuyun Yu