Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
1 year ago

Timeout Error When Connecting to SQL Server RDS via Power BI Gateway

Hi everyone,

 

I am encountering a timeout issue when trying to connect Power BI to my SQL Server RDS instance using the Power BI Gateway. The error I receive is as follows:

 

**Unable to create connection for the following reason: The analysis request operation is timed out before it was completed.**
**Details:**
SCG-CXi-DEV-RDS: Received error payload from gateway service with ID 681286: SqlException encountered while accessing the target data source.

Please have this information handy if you choose to create a support ticket.

- Session Id: f474445f-b9e2-447c-bd6b-b80ce2518e32
- RequestId: 0112b1ab-5e8a-4f60-9b60-8e0448616e84
- Cluster URI: https://api.powerbi.com
- Status code: 400
- Time: Mon Oct 14 2024 18:22:48 GMT+0530 (India Standard Time)

 

I've checked the connection and it worked fine previously. Now, it seems to be timing out while accessing the RDS instance.

 

Does anyone have suggestions on how to troubleshoot or resolve this issue? Any help would be appreciated!

2 Replies