Office 365 PowerApps/Flow On-Premises Data Gateway FAQ

Featured image

It’s great to see Microsoft introduced on-premises data gateway for providing a quick and secure connection between on premise data and Office 365 apps. This has quenched the intellectual thirst of Office 365 customers for their long wait for connecting on premise data to Office 365 apps.

Now as I see in the forums many of the Office 365 customers and technology enthusiasts has questions that they are looking for answers. Below are the some of the FAQs I have noticed in discussions.

For deployment of on-premises data gateway and connecting on premise data to Office 365 apps with screenshots, refer these blogs - Deployment of On-premises data gateway, Connect on premise data to Office 365 apps.

​1. How many gateways can be deployed in each on premise machine?

You can deploy only a single gateway

​2. Whether any additional configuration required for SharePoint 2016/SQL 2016 during gateway deployment?

No, there is no additional configuration required for SharePoint 2016/SQL 2016 during gateway deployment.

​3. Is it possible to deploy the gateway in a domain controller?

Yes, but you will receive the following error,

“Error generating an asymmetric key. The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation.”

To fix the above error, open Services console, select On-premises data gateway service change the service account from NT SERVICE\PBIEgwService to Local System and restart the service.

​4. Can I have more than one admin for a gateway?

Yes, when you manage a gateway, you can go to the administrator’s tab to add additional admins.

​5. Does the gateway admin need to be an admin on the machine where the gateway is installed?

No. The gateway admin is used to manage the gateway from within the service.

​6. Can I prevent users in my organization from creating a gateway?

No. This is on the roadmap, but currently Microsoft have not announced any timeframe.

​7. Can I get usage and statistics information of the gateways in my organization?

No. This is on the roadmap, but currently Microsoft have not announced any timeframe.

​8. Can I create multiple connections using a single gateway?

Yes, you can create multiple connections using a single gateway.

​9. Whether I need to deploy multiple gateways to connect SQL 2016/SharePoint 2016 to Office 365 apps?

No, only using a single gateway, you can connect SQL 2016/SharePoint 2016 to Office 365 apps (PowerApps, Microsoft Flow, Power BI, Logic Apps).

​10. Whether connection added in any one of the Office 365 apps will be available for access to all other apps?

Yes, for example, if you added on premise SQL connection by signing in to PowerApps, then you can also use that SQL connection for Microsoft Flow also.

​11. Whether any firewall settings required for connecting Office 365?

Yes, you need to configure firewall settings to allow the gateway to create an outbound connection using ports: TCP 443 (default), 5671, 5672, 9350 thru 9354. FYI - The gateway does not require inbound ports.

For more FAQs from Microsoft, refer the following links:

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-faq/

https://powerapps.microsoft.com/en-us/tutorials/gateway-reference/