cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chitrakant27
Advocate I
Advocate I

SQL

Hi All,

 

    I am using SQL as a data Source in the canvas application and I want my SQL server database on the network so that all members of my team are able to use that database when I share my canvas app with my team. So how can I make my SQL database a common data source for everyone? We can do it from Azure AD, I know but I want to know another method so If anyone having an idea about please help me.

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @Chitrakant27 ,

 

When you share an app that uses certain connections, the app connection is implicitly / automatically shared.  SQL is one such connection.  Please read more here.

 

You can look at using a service account for the SQL connection with the relevant access to your SQL database.  That way, when you share the app, the SQL connection with the service account will be implicitly shared.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

kierian
Community Support
Community Support

sharing PowerApps doesn't include sharing access to database 

you can share SQL connector and will give user access to app access to database but it will use user credential who initially created this connection.

 

Share resources used by canvas apps - Power Apps | Microsoft Docs

 

Hope this helps.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,953)