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 / Dataverse table shared...
Power Apps
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!

I have the same question (0)
  • ivan_apps Profile Picture
    2,189 Moderator on at

    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.

  • Verified answer
    AllanDeCastro Profile Picture
    412 Most Valuable Professional on at

    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.

     

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 462

#2
WarrenBelz Profile Picture

WarrenBelz 425 Most Valuable Professional

#3
Vish WR Profile Picture

Vish WR 291

Last 30 days Overall leaderboard