SOLVED

difference between Power BI gateway and Microsoft flow gateway

MVP

Hi guys. Could you help me any information about difference between Power BI gateway and Microsoft flow gateway. Or is it the same? And the second question is may I use direct connection with my data (SQL server) using MS flow without having gateway? Thanks.

3 Replies
Hello Sergii,
My two cents here:
(1) Microsoft Flow Gateway is curretly the OnPremises Data Gateway that can be used across Flow, PowerApps and PowerBI...so the key difference is that you only need this Data Gateway for the three cloud services and I think any new one being added by Microsoft: https://flow.microsoft.com/en-us/blog/on-premises-data-gateway/
(2) You need the Data Gateway to get your SQL Server Data OnPremises unless you expose your server in a way you don't need it...for instance, you could create an Entity Framework Data Model to map your OnPremises Databases, create a REST API that exposes the Entity Framework Data Model and consume that REST Service from Flow, Power BI or other...

IMHO your best choice here is to use the Data Gateway

@Juan Carlos González Martín wrote:
Hello Sergii,
My two cents here:
(1) Microsoft Flow Gateway is curretly the OnPremises Data Gateway that can be used across Flow, PowerApps and PowerBI...so the key difference is that you only need this Data Gateway for the three cloud services and I think any new one being added by Microsoft: https://flow.microsoft.com/en-us/blog/on-premises-data-gateway/
(2) You need the Data Gateway to get your SQL Server Data OnPremises unless you expose your server in a way you don't need it...for instance, you could create an Entity Framework Data Model to map your OnPremises Databases, create a REST API that exposes the Entity Framework Data Model and consume that REST Service from Flow, Power BI or other...

IMHO your best choice here is to use the Data Gateway

Hi Juan,

Thank you for responding so quickly. As I understood correctly, you say that Microsoft Flow gateway and Power BI gateway are the same thing? Am I right?

best response confirmed by VI_Migration (Silver Contributor)
Solution
Both the gateways are same. You can view more FAQs on this topic from below link
http://www.jijitechnologies.com/blogs/on-premises-data-gateway-FAQ
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution
Both the gateways are same. You can view more FAQs on this topic from below link
http://www.jijitechnologies.com/blogs/on-premises-data-gateway-FAQ

View solution in original post