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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard