Forum Discussion
Importing Dataverse table with Microsoft Entra ID 'aaduser' lookup column
Hi RH10 ,
which I assume is the 'userid' value for a particular userYes it is userid.
Please try to connect to the system user Table, it contains the user name and user id. The field corresponding to id is Azure AD Object ID:Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Did you ever get a response to this question? I have the same inquiry.
I did not. What I'm going to end up doing is using the AAD Table and just using a separate custom power bi report. It's a pain though because you can't pull the AAD Table into Power BI directly, so I'm using a dataset that was published for a separate Power BI App (Powerstacks - BI for Intune App) that pulls in all user data and then creating a relationship betwen my Dataverse Table and the User Table in the BI for Intune dataset to link together my user fields and pull them into the report I build.
Not my favorite way to do it, but it will work 😔
I also ended up implementing a workaround. My report also utilzes the "User" table (which looks up data in the AAD table). I ended up adding text columns to the User table for the data I needed. New columns:
1. Company (text)
2. Department (text)
3. Manager Display Name (text)
4. Manager UPN (text)
I then created the following flow to copy the data over from the user's Office 365 profile when there is a change:
Glad you found at least a workaround for what you needed! Thanks for the response.