How to configure the gateway for my Power BI service without Azure?

[Satish_Kumar]

Hi All,

I have one Task to complete i.e. i want to connect my data source with my locally installed Gateway ,which i downloaded from Power BI gateway and do not have any AZURE database so can i connect with Gateway which is installed locally in my system,

if yes please guide me with steps involve.

Thanks In Advance!!!

Regards,

Satish Kumar

[Seth_C_Bauer]

@Satish_Kumar Which gateway did you install? The personal or the On Premises Data Gateway? The personal gateway will just work for supported datasources, the OPD gateway will require that you create a data source first in the PBI Service.

This example is for a SQL Server, but the steps would apply to other sources as well.

[Satish_Kumar]

@Seth_C_Bauer

I have installed the on premise Gateway avilable from Power BI.

[Seth_C_Bauer]

@Satish_Kumar In the Power BI Service, have you created a data source for the gateway? Under Settings -> Manage Gateways -> Add Data Source?

[Satish_Kumar]

@Seth_C_Bauer

Here is the main problem its is showing the gateway is offline and thatwhy i am not able to connect to the data source.

[Satish_Kumar]

@Seth_C_Bauer

[v-qiuyu-msft]

Hi @Satish_Kumar,

From the image, it seems that the data gateway isn't online. Please verify the gateway is running.

Then start the on-premise data gateway, sign in with your account, make sure the status like below:

Best Regards,
Qiuyun Yu

[Satish_Kumar]

@v-qiuyu-msft

yes my On Premise gateway is running but i am able to see this message as you shown to me in pic.

[v-qiuyu-msft]

Hi @Satish_Kumar,

Can you find the app on-premise data gateway in your computer, start it and sign in with your account?

Best Regards,
Qiuyun Yu

[Satish_Kumar]

@v-qiuyu-msft

I tried but its always shows me that the gateway is offline.

[v-qiuyu-msft]

Hi @Satish_Kumar,

How about updating the data gateway to the latest version? Make sure sign in account in data gateway is the same address as you used to login Power BI service.

Best Regards,
Qiuyun Yu

[Seth_C_Bauer]

@Satish_Kumar I assume you had no issue setting up the gateway on the server.

Did you change the Service account user?

Is your server part of the same domain registered with your tenant?

Have you accomodated all the firewall and proxy configurations?

[Satish_Kumar]

@Seth_C_Bauer

No i have not change the server Account.

And all firewall activity is done with my machine.