Unable to create data source. Timeout expired. The timeout period elapsed prior ...

[karo]

Hi,

Do you know how to troubleshot scenario when we are not able to create connection for OData type data source on On-Prem Data Gateway (standard mode) and we get an error:

"Unable to create data source. 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:

XXX: Timeout expired. The timeout period elapsed prior to completion of the operation. Please have this information handy if you choose to create a support ticket.

ActivityId: XXX Cluster URI: https://api.powerbi.com   

Status code: 400 Time: Tue Jan 24 2023 15:31:59 GMT+0100 (Central European Standard Time)" 

Notes: 

- Refresh via Power BI Desktop works fine 

- Gateway in Standard Mode, Gateway version 3000.154.3 

Regards, 

Karo 

[karo · Accepted solution]

In case anyone encounters a similar problem in the future please Skip Test Connection to resolve the issue. 

[gilmorez]

Does the connection actually work if you skip the connection test?

[karo]

Anyone? Any hints?

[AnkitKukreja]

Hi @karo 

I hope you are able to connect to this source through Desktop. Assuming you have the right permission, then I think this could be the issue
https://learn.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-220-gateway-data-so...

[karo]

Hi @AnkitKukreja thank you for the reply, but we do not have problems with updating credenntials and we already have Admin rights on gateway. The issue is when we are trying to add data source. And what is quite strange, it is funny, we whare able to add other similar data sources, for the same project without problems.