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

[manoj_0911]

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!

[v-cgao-msft]

Hi @manoj_0911 ,

Similar question, please check that it is the cause of the problem:

sql server - SqlException encountered while accessing the target data source

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

Is your Power BI Gateway VM on the same AWS subnet as the SQL Server?