Failed to update data source credentials: Incorrect function

[Digger]

I trying to auth to google drive folder  (which worked 3month before today)

Today stupid PBI stop working and show always error

Failed to update data source credentials: Incorrect function

1. Nothing was changed!!!

2. I tryed reinstall gateways (both personal and onpremise) does not help

3. Itryed reload PBI file to web, does not help

[v-yangliu-msft]

Hi  @Digger ,

Hi, if it is convenient, can you tell me if you solved the problem yourself through the solution given in your reply above? If you solve it, you can mark your answer and it will help others.

Best Regards,

Liu Yang

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

[nupurs]

I created a dashboard in Pwer bi desktop where my data sources are Redshift and SQL server. I can see everything in the desktop version, but after publishing, i see this: 

Also, i tried the same creds that I had entered in the desktop version, but everytime the note says that the credentials are invalid. Following error msg was shown while try to validate the credentials again:

Unable to update this data source's credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.



Details: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not translate host name "abt-aa-landing-redshift-cluster-nonprod.abbott.com" to address: Unknown host Please have this information handy if you choose to create a support ticket. ActivityId: 51f336e6-3783-416f-b697-e1108b2bbb99 RequestId: 1760c6ea-c947-424f-a754-d1f2c2181475 Cluster URI: https://api.powerbi.com Status code: 400 Time: Tue Nov 08 2022 14:42:48 GMT+0530 (India Standard Time)

[v-yangliu-msft]

Hi  @Digger ,

You can try the following:

Open a CMD command window, type Whoami, and search for your domain account.

Then click the gear -Manage gateway - to enter the gateway interface.

Find the corresponding data source and enter the Setting.

Put the searched domain account and related password in it, do not click Skip test connection.

If it still doesn't work, you can click on Show details of the error message and tell us the details, we can help you better.

Best Regards,

Liu Yang

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

[Digger · Accepted solution]

@v-yangliu-msft  i found problem problem what PBI didnt see full path, i just enter G:\ and it working