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 / Power Platform authori...
Power Apps
Answered

Power Platform authorization to data access

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dear all,

 

I have a question on the data access authorization of PowerApp apps, in case someone does not use Dataverse as the data source. One can define access rights to a Dataverse instance, but what happens if we use a PowerApp app that connect to an Azure SQL database (or any other data source)?

  • How can I enforce different authorization per user/role via PowerApp app interface?
  • Can I make the data retrieval requests (like queries) to that data source at PowerApp app-user level? Or does it have to be at application-level (the data source sees the PowerApp app as the only user)?

Thank you.

I have the same question (0)
  • Verified answer
    AbdulWahab Profile Picture
    517 on at

    Hi @Anonymous ,

     

    Here is the related link: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections-list#security-and-types-of-authentication

     

    If I answer your question then please mark it as verified.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
    Youtube Channel: https://www.youtube.com/channel/UCBjgLqLK_2kU-3bwo4McrTw

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for the reply. Could you please check if I understand the content in the link you shared correctly: 

     

    Azure AD Integrated:  "If the data is appropriately secured on a back-end your users can only see what they're authorized to see based on their credentials. .... For instance you can grant access, deny access, or refine what a user or set of users can see all on the back-end data source."

     

    So, Azure AD Integrated connection can be used to distinguish the individual users of the apps separately when accessing to the SQL database; instead of appearing the application itself as the single user.

    Otherwise, all the data within the database become visible at the application level.

  • AbdulWahab Profile Picture
    517 on at

    Hi @Anonymous ,

     

    Yu are right.

     

    If I answer your question then please mark it as verified.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
    Youtube Channel: https://www.youtube.com/channel/UCBjgLqLK_2kU-3bwo4McrTw

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard