Failed to update data source credentials

[h_pai_]

Hi Community, facing the following issue on the Power BI service when using Web connector.

The credentials are validated and able to fetch data on Power BI desktop, but the credentials are not validated on service side and thus not able to refresh the data.

Any idea as to what could be the problem or solutions to it?

PS: I'm trying to pull data from a third party application

[florianh]

I had the exact same issue. For me it worked to turn on the “skip test connection”. I use the following setting:

[madhukardevale]

Is there any Rest API available to update this. Tried below one but no luck. skipTestConnection is not present in the payload

PATCH https://api.powerbi.com/v1.0/myorg/gateways/1f69e798-5852-4fdd-ab01-33bb14b6e934/datasources/252b9de...

[badda_khan]

Hi Folks,
Hope you are amazing.
I need your need you help. I have created a sales dashboard fro my client. Its has card visuals like one card is showing current selected period sales and secound one is showing the sales period but for last year. Now I applid YTD slicer by creating new tables which filter date filter accordingly. Now the issue is when I apply YTD, QTD or MTD it filters the date table for current year due to which previous year calculation measures goes to blank. But I need to show the values for last year also. 
Any idea how to resolve this issue.

[badda_khan]

Hi @h_pai_ 
Can you please share the details, if you managed to resolve this issue. I am facing the same issue and I am pullying data from Postsgres.
Regards

[h_pai_]

Hi @badda_khan , setting up a gateway on a VM should do

[rachelgomez1234]

Solution: If you get a credentials message, it could mean:

The usernames and passwords that you used to sign in to data sources aren't up to date. In the Power BI service, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

Mashups between a cloud source and an on-premises source, in a single query, fail to refresh in the gateway (personal mode) if one of the sources is using OAuth for authentication. An example of this issue is a mashup between CRM Online and a local SQL Server instance. The mashup fails because CRM Online requires OAuth.

This error is a known issue, and it's being looked at. To work around the problem, have a separate query for the cloud source and the on-premises source. Then, use a merge or append query to combine them.

Regards,

Rachel Gomez

[h_pai_]

Thanks for the reply but may be I was unclear.

I'm using rest API to pull data using the Web connector which is available only on Power BI desktop. The API requires authentication. The credentials for the API work when using the desktop but give out the error in the datasorce credentials on the Power BI service

[Anonymous]

Hi, did you get solution for the Problem, i am facing the same issue...Can you please help me..
For me also the api data is working in the desktop when i deploy the dashboard it is giving error for authentication , in desktop i am using Basic authentication but if i use the same in web it is  not working

[h_pai_]

Thanks for the reply but may be I was unclear.

I'm using rest API to pull data using the Web connector which is available only on Power BI desktop. The API requires authentication. The credentials for the API work when using the desktop but give out the error in the datasorce credentials on the Power BI service

[learner03]

@h_pai_ Have you sorted this? I am having the same issue

[h_pai_]

Yes, I was able to solve this by setting up a On-premises data gateway

[abhay_jagtap]

Hi,

I'm also facing the same issue, and for me "Gateway Connections" is disabled. 

[h_pai_]

Hi @abhay_jagtap ,

You need to first setup the gateway on a VM for it to work. You can use it on your local machine but remeber do not turn it off

[Anonymous]

Can you explain about this , Is it a On premise gateway?

[learner03]

@h_pai_ But, if it is fetching through API, shouldn't it be a cloud sorce and we shouldn't need gateway for this. I am having same issue. If I pas it through gateway, it works but as being a cloud source, it shouln't use gateway. 

[h_pai_]

Ideally yes it should not be using gateway. But doesn't seem to work with out it. I don't know the reason behind it. But looks like there are issues it is a dynamic data source