cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Failed to update data source credentials / sharepoint online / status code 400

Hi

 

I have tried seaching for a solution to this problem but have not found any so far.

I have created a report in power bi desktop using a sharepoint online list and have published it to power bi. So far so good. When I click refresh on the dataset, it fails. 

"Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

 

When I try to update the credentials and set the to "Authentication method: Windows" and "Privacy level: Organisational" I get "Failed to update" with Status Code: 400

Anyone know whats wrong?

Thx
Jorgen

1 ACCEPTED SOLUTION
venal
Memorable Member
Memorable Member

@Anonymous 

 

Power Bi Service >> Data Set Settings >> Data Source Credentials >> Select the data source (ex:- share point > edit credentials > use "OAuth2 > Privacy level (Organizational)).

PBIS-Data Set Settings.JPG

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

View solution in original post

2 REPLIES 2
venal
Memorable Member
Memorable Member

@Anonymous 

 

Power Bi Service >> Data Set Settings >> Data Source Credentials >> Select the data source (ex:- share point > edit credentials > use "OAuth2 > Privacy level (Organizational)).

PBIS-Data Set Settings.JPG

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

View solution in original post

@Anonymous Use "OAuth"


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.