Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Suggested answer

Dataverse "AAD user" Azure Active Directory table is not showing

(0) ShareShare
ReportReport
Posted on by 55
Hi experts,
In Dataverse in table list "AAD table "(Azure active Directory User) table is not showing, i search it. any idea?
 
Thanks and Regards,
Shabir Ahmad
  • Suggested answer
    Dataverse "AAD user" Azure Active Directory table is not showing
    Hi Shabir,

    Steps to Resolve AAD User Table Visibility Issue:

    1. Search Using Schema Name:

      • Instead of searching for the table using its friendly display name, try searching using its schema name: aaduser. Virtual tables like AAD User might require exact schema names.
    2. Check Table Filters:

      • Ensure that you’ve selected All tables in the Dataverse table list, rather than just "Recommended" or "Custom" tables. This filter can hide system and virtual tables.
    3. Verify Virtual Entities Data Sources:

      • Go to Settings > Advanced Settings > Administration > Virtual Entities Data Sources.
      • Verify that the Azure Active Directory connection (data source) is set up and active. The AAD User table relies on this data source.
    4. Ensure Proper Permissions:

      • Make sure your account has the necessary permissions, such as System Administrator or a custom security role with the ability to view and manage virtual tables.
    5. Check Virtual Tables Feature:

      • Confirm that the Virtual Tables feature is enabled in your Dataverse environment. This may require admin access to your Power Platform settings.
    6. Customization Conflicts:

      • Ensure there are no conflicts with unmanaged solutions or customizations that could affect the visibility of system tables like the AAD User table.
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 358 Super User 2025 Season 1 on at
    Dataverse "AAD user" Azure Active Directory table is not showing
    The "AAD User" table is a virtual table connected to Azure Active Directory, and it might not appear because it is not automatically included in the list of standard tables or because virtual tables are not enabled or configured in your environment.
    Here are the steps to resolve this:
    1. Search for the table using its schema name aaduser instead of the friendly display name, as virtual tables sometimes require exact names to show up in the search.
    2. Check the table filters in the Dataverse list. Ensure you’ve selected "All" tables instead of "Recommended" or "Custom," as these filters can hide system and virtual tables.
    3. Go to Settings > Advanced Settings > Administration > Virtual Entities Data Sources and verify that the Azure Active Directory connection (data source) is set up and active. The AAD User table depends on this connection.
    4. Ensure your account has the proper permissions, such as the System Administrator role, or a custom security role that allows you to view and manage virtual tables.
    5. If the table still doesn’t appear, check whether the virtual tables feature is enabled in your Dataverse environment. This might require admin access to your Power Platform environment settings.
    6. Ensure there are no customization conflicts or unmanaged layers affecting the availability of system tables like the AAD User table.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,318 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics