AAD User Table | Query per Odata or Dataverse Connector PBI

[P3Sven]

Hi lovely community,

just wondering why I can't query dataverse table "AAD User". 

Have sys admin role and can read all records "directly" via make.powerapps.com, but why not via API?

Is there another way to get all users of AAD User table or other?

I need all users incl. "company name" column? (unfortunately its not included in systemuser table)

BR,

Sven

[dpoggemann · Accepted solution]

Hi @P3Sven ,

The systemuser table is the table in Dataverse with users.  I don't know of the AAD User table in Dataverse, the AAD user is is Azure Active Directory and I would expect you should utilize something like Power Automate to pull this information from AAD and augment as needed to the systemusers table in Dataverse.  

An example of a flow that is doing something similar:  https://2die4it.com/2020/09/02/get-set-manager-of-cds-d365-users-with-power-automate-flow/ 

[EricRegnier · Accepted solution]

Hi @P3Sven,

The issue with the Odata query you're trying is that your not authenticated. You'll need to pass the auth token somehow but I'm not sure how to with the Odata.Feed function. Even though your a system admin in Dataverse, AAD is another system/platform which required different privileges.

There is another way with the Office 365 User connector which will be simpler. Here's an example

More info: https://docs.microsoft.com/powerapps/maker/canvas-apps/connections/connection-office365-users?WT.mc_...

Hope this helps!

[P3Sven]

Hi @dpoggemann , Hi @EricRegnier ,

thanks for your replies!

Also have wondered about AAD User Table but yes, I also guess it's another system with other authorization method.

I need to query all users incl. company name. I will create a new company name column in systemuser table and will update it with power automate via Office 365 connector..

Thank you!

BR,

Sven

[NHelgren · Accepted solution]

We have just released the new AAD User virtual table. I'd based in Graph and uses OBO auth. With it you are able to retrieve AAD user data through the virtual table. Check out my recent post on it. 

New table in Dataverse - AADUser - Power Platform Community (microsoft.com)

[RakeshPower]

Hi @NHelgren , we have started using AAD User Table in Model Driven APP. However, since our tenant has >100K users, the loading part in drop-down search is slow and very much evident to end user and impacting the user experience.

Is there a way to use some filters/search in this lookup column to avoid delays? are there any known issues in context to number of users in tenant on its performance. Thanks in advance. 

[EricRegnier]

Hi @RakeshPower, you can create custom views on AAD User and bind the lookups in your model driven app to those views. Cheers