How the remote gateway can be auto detected in service?

[jashukla]

Hi,

We have two EC2 instance running.

EC2-1 instance for DSN, PowerBI Desktop & service running.

EC2-2 instance for DSN & gateway.

Both are under the same VPC and private subnet.

Can someone please help how service running on EC2-1 can auto-detect the gateway of EC2-2?

Thanks!

[v-zhengdxu-msft · Accepted solution]

Hi @jashukla 

Please ensure both EC2 instances can communicate with each other. This involves checking security group settings to allow inbound and outbound traffic on the ports used by Power BI and the On-premises Data Gateway. Typically, this would include ensuring that the necessary ports (e.g., TCP port 443 for HTTPS) are open between the two instances.

On EC2-2, where your gateway is installed, make sure the gateway is properly configured and registered with the Power BI service. This involves logging into the Power BI service and adding the gateway to your account. Ensure that the Power BI service running on EC2-1 is using an account that has permissions to access the gateway.
Here for your reference:

Use the on-premises data gateway app | Microsoft Learn

In some case, manual intervention might be required to link the service to the gateway. This can be done through the Power BI service by navigating to the dataset settings and configuring the gateway connection.

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.