Hello Power BI Community,
I’m trying to set up a cloud connection in Power BI Service for my report that connects to an AWS RDS SQL Server instance. I successfully published the report from Power BI Desktop, but I encounter the following error when trying to create a cloud connection for scheduled refresh:
```
Unable to create connection for the following reason: We could not access the data source. Please make sure you have permission to access the data source and that your credentials are correct.
Details:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)
```
Here’s how I’ve set up the connection:
- Connection Name: AWS RDS
- Connection Type: SQL Server
- Server: [MASKED SERVER NAME],5433
- Database: [MASKED DATABASE NAME]
- Authentication Method: Basic
- Username: [MASKED USERNAME]
- Password: [MASKED PASSWORD]
- Encrypted Connection: Yes (Encrypted)
- Privacy Level: Organizational
Could someone help me understand what might be going wrong, or if I’m missing something in the configuration?
Thank you for your help!
