Power BI Service connection to SQL Server on AWS EC2 instance not connecting. Have gateway installed

[kriskmk]

I am trying to connect Power BI Service to connect to SQL Server that is installed on AWS EC2. Installed On-Prem Gateway and configured, which is in online state. Followed Power BI Service connection to SQL Server on AWS E... - Microsoft Fabric Community

 Keep getting "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)". 

The above error is from the Gateway error logs (On-Prem Gateway installed on the AWS EC2). Need help.

[kriskmk]

After I posted this message, I realized one thing. 

I got this idea, where I figured that the Gateway and SQL Server on the same EC2 instance, Gateway is not able to reach SQL Server. All I had to do was to set the IP (private, just to be safe also gave public IP) in the Security Group of the EC2 instance, only gave access to MSSQL (port 1433). Power BI service connected to the SQL Server.