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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
karo
Post Patron
Post Patron

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

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 

1 ACCEPTED SOLUTION
karo
Post Patron
Post Patron

 

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

View solution in original post

5 REPLIES 5
karo
Post Patron
Post Patron

 

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

Anonymous
Not applicable

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

karo
Post Patron
Post Patron

Anyone? Any hints?

AnkitKukreja
Super User
Super User

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...

 

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

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. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors