Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
In case anyone encounters a similar problem in the future please Skip Test Connection to resolve the issue.
In case anyone encounters a similar problem in the future please Skip Test Connection to resolve the issue.
Does the connection actually work if you skip the connection test?
Anyone? Any hints?
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...
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
38 | |
26 | |
24 | |
21 |