cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Create and share on-premises connections across power bi, flow and powerapps

I installed Power BI Gateway on one of our servers and then I went in and created a Data Source connection to a SQL Server DB and a shared folder from Power BI -> Manage Gateways screen. 

When I go into Microsoft flow or Powerapps, I am not able to see that connection though. Should it show up? 

 

My assumption was that I can install a gateway and configure all the different connections and use it across Power BI , Flow and Powerapps.  Is that not the case? Have I understood this wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @VickyD,

 

You could use the same Gateway in Power BI, PowerApps, MS Flow to access On-prem database like SharePoint, Sql server etc.

However, the connection established in Power BI is not related to the connection established in MS Flow. If you want to establish a connection with On-prem connector in MS Flow, you need to create a new connection.

The connection established between MS Flow and PowerApps can be used together, provided that the environment selection must be the same.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @VickyD,

 

You could use the same Gateway in Power BI, PowerApps, MS Flow to access On-prem database like SharePoint, Sql server etc.

However, the connection established in Power BI is not related to the connection established in MS Flow. If you want to establish a connection with On-prem connector in MS Flow, you need to create a new connection.

The connection established between MS Flow and PowerApps can be used together, provided that the environment selection must be the same.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (13,104)