Power Apps

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

(0) Share

Report

Posted on by Shabir Ahmad

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Garima_PowerPlatform 170 on at

Like (0)

Report
Hi Shabir,
Steps to Resolve AAD User Table Visibility Issue:

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.

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.

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.

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.

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.

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.

Was this reply helpful? Yes No