Unanswered

Dataverse table shared with the tenant

(1) Share

Report

Posted on by pae1

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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

ivan_apps 2,187 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

AllanDeCastro 412 Most Valuable Professional on at

Like (1)

Report
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:
Go to the Power Platform Admin Center.
Select your environment.
Navigate to Settings > Users + permissions > Security roles.
Create a new security role (e.g., "TenantWideReadAccess").
Configure the permissions for the security role, ensuring that it has read access to the tables you want to share.
Assign the Security Role to an Azure AD Group:
In Azure Active Directory, create a new security group if you don’t have one already. This group will contain all users in your tenant.
Add all the users to this security group.
In the Power Platform Admin Center, go to the Settings > Users + permissions > Teams.
Create a new team and link it to the Azure AD security group created in the previous step.
Assign the previously created security role (TenantWideReadAccess) to this team.
Set Table Permissions in Dataverse:
Ensure the table permissions in Dataverse allow access based on the security role.
Go to Tables, select the table you want to share, and configure its permissions to match the security role.

Was this reply helpful? Yes No