Forum Discussion
Importing Dataverse table with Microsoft Entra ID 'aaduser' lookup column
Hello everyone,
I'm running into a weird problem when importing a Dataverse table that contains a lookup column to the Microsoft Entra ID 'aaduser' table into Power BI Desktop. All of the values in this column are a string of characters with dashes in between, which I assume is the 'userid' value for a particular user. However, I want to import just the display names instead. How do I go about accomplishing this?
I've tried importing the 'aaduser' table directly after selecting Dataverse in the Get Data option so that I can create a relationship between these tables, but it doesn't show up. I've also tried using the OData connector to import the table, but refreshing is very slow because there are tens of thousands of users, so I would like to avoid that. Does anyone else have any ideas?
Thank you in advance for your help.
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.
6 Replies
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.
