You’re offline. This is a read only version of the page.
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)?
Thank you.
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
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.
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
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (