web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Hide SQL Connection wi...
Power Apps
Answered

Hide SQL Connection with the App in Default Environment while sharing

(0) ShareShare
ReportReport
Posted on by 9

Hello,

I would like to hide the Azure SQL connection not to view all tables which I have shared with other users. They should see the data through the app only. Right now when I share an App with users, they can see the connection and able to create apps with that connection.

 

Thanks in advance.

Categories:
I have the same question (0)
  • Verified answer
    eka24 Profile Picture
    20,925 on at

    Please Shane Young Has given detailed explanation on inability to do that in Default environment.

    You could create another environment to do that:
    https://youtu.be/NqQGysNCac0?t=7

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Praveen_SP ,

    Do you want others could only view the sql table connected with the shared app, not could not view other sql tables?

    Actually, there's no feather about hiding connections in powerapps.

    I think the issue that you want is sql table's permission.

    To make others only have permission about the table connected with the shared app, but you could have permission about the whole database.

     

    Here's the solution:

    1)create a sql user for shared users

    4151.PNG

     

    2)give permission about the database that you want to connect with to this user

    (choose database, food is my database)

    4152.PNG

     3)grant this user with the specific sql table's permission

    (food is my database name,food_info is my table name, I give this user the permission about this table)

    4153.PNG

     Then make this user have no permission on other tables in this database.

    4154.PNG

     

    Here's a doc about how to grant permission to user in table level in details for your reference:

    https://manage.accuwebhosting.com/knowledgebase/1255/How-to-assign-particular-permissions-to-SQL-server-database-user-from-SQL-Server-Management-Studio.html

     

    4)Then this userwill only have permission to the specific sql table, not all tables inside the database.

    5)When you create connection with sql table in powerapps, please log in with this user. (Connect with sql by using the certification information of the user above)

    4155.PNG

     

    6)Then if you share this app, share this connection with others, others could only log in sql by this specific user who only has permission to specific table, not all tables inside the database.

    7)If you want to connect with other tables in your other apps, you just need to connect with sql with other sql user's certification information(with the permission on the table that you want.)

     

     

    Best regards,

     

  • Praveen_SP Profile Picture
    9 on at

    Hello @eka24 ,

     

    Thanks for your reply. I watched video and it looks like I need to get one PowerApps standalone license to create environment, app and connections to make it secure while sharing. 

  • Praveen_SP Profile Picture
    9 on at

    @v-yutliu-msft ,

     

    Thanks for your reply with SQL security. This will also helpful in some cases. But I would like to hide data connections shared with an app.

     

    Regards,

    Praveen

     

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Praveen_SP ,

    I'm afraid this feather is not supported in powerapps yet.

    If you share your connection, your whole data about the connection will be shared too. 

    The permission are the same and the data source that could used is the same.

     

    So I suggest you use limited permission of sql user tocreate connection with sql in your shared app.

     

     

    Best regards,

  • Praveen_SP Profile Picture
    9 on at

    Hello @v-yutliu-msft, we got the Power Apps Per User Plan and able to create environment and hide SQL connection with other users. So, the SQL security you provided will be useful near future as a backup. 

    Thank you so much!

     

    -Praveen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard