Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Dataverse table shared with the tenant

(1) ShareShare
ReportReport
Posted on by 86

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!

  • Verified answer
    AllanDeCastro Profile Picture
    412 Most Valuable Professional on at
    Re: Dataverse table shared with the tenant

    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.

     

  • ivan_apps Profile Picture
    2,187 Super User 2025 Season 1 on at
    Re: Dataverse table shared with the tenant

    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.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics