Forum Discussion
RH10
1 year agoHelper I
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 ...
- Anonymous1 year ago
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.
Anonymous
1 year agoNot applicable
Hi RH10 ,
which I assume is the 'userid' value for a particular user
Yes 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.
RH10
1 year agoHelper I
It worked, thank you very much!