Gateway instllation issue

[pradeepXE]

We are trying to install the PowerBI gateway, but having the issues with the firewall settings, hat fire wall settings do we need to have to isntall the powerBI gateway, any suggestions please.

Kind Regards,

Pradeep

[Anonymous · Accepted solution]

@pradeepXE 

There are a couple of types of gateways (Personal and On-Premise) and you will need the On-Premise one.

When implementing this I selected:

Data Source Type

Server 

Database

Then used a service account to link to the server.

The service account has local admin permissions on the server and in SSMS had sysadmin permissions.

I hope this helps.

[pradeepXE]

Thanks

---

@Anonymous wrote:

@pradeepXE 

There are a couple of types of gateways (Personal and On-Premise) and you will need the On-Premise one.

When implementing this I selected:

Data Source Type

Server 

Database

Then used a service account to link to the server.

The service account has local admin permissions on the server and in SSMS had sysadmin permissions.

I hope this helps.

---

[Seth_C_Bauer]

@pradeepXE 

Here is a post that covers this topic:

https://community.powerbi.com/t5/Service/Firewall-setup-IP-used-by-Power-BI-Service-during-data-refr...