Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Failed to update data source credentials:

We have been having an issue in PowerBI Service where I am unable to set up a scheduled refresh. I keep getting an error message telling me that it failed to update the data source credentials for my dataset.

 

 {33470733-B470-4F7A-B1C9-8894A81E44D3}.png.jpg

 

The report file (.pbix) is published and is linking to a Sharepoint list, when working in PowerBI Desktop I do not have any issues manually refreshing directly from Sharepoint using Organization authentication. It concerns only the published version.

 

 

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@RevathiSappidi,

Do you connect to on-premises SharePoint list or SharePoint online list in Power BI Desktop? If you use on-premises SharePoint list, please use Windows authentication in Power BI Desktop, then re-publish PBIX file to Power BI Service and set schedule refresh with gateway.

However, if you use SharePoint online list, please use organizational account in Power BI Desktop and use OAuth authentication in Power BI Service.

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info
 
DerekTrujillo
Frequent Visitor

I have a similar issue and was hoping to find a solution here. 
I am using a sharepoint online list and don't see an OAuth option in the Power BI service. 

Anonymous
Not applicable

I have a similar issue. 

I connect to excel file on SPO.

When I use desktop app - there is no error.

When I publish it, I can't change credentials. And I can't see OAuth2 authentication method - I can use Windows only.

Anonymous
Not applicable

do we have any solution for this problem even i cant see oAuth during connection.

TTVenky
New Member

Facing the same problem here. 

BartWitteveen
New Member

Was there a solution for addin the option OAuth to power bi service?

regards, Bart