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.
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.
It worked, thank you very much!
Hoping your account is still active and you can help. Here's my issue:
If I deploy my solution in our default environment, all active users will be present in the systemuser table, however, the systemuser table does not contain all of the same info as the aaduser table, particularly the "Office Location" field which we use to designate our staff to a particular practice, so using the Entra ID User table would be ideal, but since its a virtual table it bricks the embedded Power BI report in the model-driven app and can't be added as a data source in Power BI Desktop.So my question for you is, what is the best way to ensure I have all possible user information in a table that will update automatically and can be used in Power BI for reporting? We have around 3,000 active staff members so creating my own table and adding/updating/removing using Power Automate isn't a viable solution, but there has to be a way for me to access a live record of staff in my org to be able to assign them an asset. Any help/guidance you can provide would be much appreciated.
Thank you!
-Greg
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 😔
