cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DarshanGandhi Frequent Visitor
Frequent Visitor

Refresh failed - Status code 400

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?

PowerBI_RefreshError.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Refresh failed - Status code 400

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Moderator v-qiuyu-msft
Moderator

Re: Refresh failed - Status code 400

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
DarshanGandhi Frequent Visitor
Frequent Visitor

Re: Refresh failed - Status code 400

Hi Qiuyun Yu,

 

Yes it indeed worked out.

Thanks for your help.

 

Regards.

DG

Moderator v-qiuyu-msft
Moderator

Re: Refresh failed - Status code 400

Hi @DarshanGandhi,

 

Glad to hear the issue is gone Smiley Very Happy

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SabaM Frequent Visitor
Frequent Visitor

Re: Refresh failed - Status code 400

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 updatesBi222.JPG

 

tobiasmoehrke Frequent Visitor
Frequent Visitor

Re: Refresh failed - Status code 400

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.

Screenshot 2018-09-27 at 14.52.24.png

Cheers

Tobias

chocy Frequent Visitor
Frequent Visitor

Re: Refresh failed - Status code 400

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

 

datasourceerror.JPG

faizannaeem Regular Visitor
Regular Visitor

Re: Refresh failed - Status code 400

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 Frequent Visitor
Frequent Visitor

Re: Refresh failed - Status code 400

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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 376 members 3,791 guests
Please welcome our newest community members: