Hello everyone,
Is there a way to share a Dataverse table with the whole tenant without adding all the users to the Power Platform Environment where the table resides?
Thanks in advance!
Hello,
Sharing Dataverse tables across the entire tenant without adding each user to the Power Platform environment directly can be achieved by using Microsoft Dataverse’s security roles and Azure Active Directory (AAD) (now Entra Id) groups. Here’s a step-by-step approach to accomplish this:
Create a Security Role in Dataverse:
Assign the Security Role to an Azure AD Group:
Set Table Permissions in Dataverse:
You could create a dynamic security group in Entra that gets all active users in the tenant. Then create a Dataverse team linked with the Security Group via the admin center. Assign that security group/team a security role that will have the proper permissions you need on that table. If you have an environment security group, be sure this new group is a member of it or make it the security group itself.
the dynamic security group will create users in Dataverse and auto-assign the security role without any intervention at that point.
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1