web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataverse "AAD user" A...
Power Apps
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 59
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
I have the same question (0)
  • Suggested answer
    SwatiSTW Profile Picture
    741 Super User 2025 Season 2 on at
    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.
  • Suggested answer
    Garima_PowerPlatform Profile Picture
    170 on at
    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard