'How do i import Azure AD users into my PowerBI

I have to make a Asset management in SharePoint, now i have to make something in PowerBi so when you search on the name and than the devices owned by the person come up.

I used the "jan bakker" way before using power automate but this gives the activities by a user so the name is in the list multiple times and this is not what i need. also this list doesnt match with my current user ID which is given by sharepoint. https://janbakker.tech/use-graph-api-data-in-power-bi-using-logicapps/

if anyone knows a good solution i would love to hear!

I imported a excel sheet but that isnt the way because the list of people is around 150 users and gets changed sometimes.

i also tried the way jan bakker said but this is more like activities and the name of a person is the up to 20 times. and no usefull/matching ID with the sharepoint current user ID



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source