Office365 User information (like in PowerApps)

[vladimir84]

How to get the Office365 information for the list of e-mails in the data queries window? Essentially, I need person's job title, department, phone, so that they can be filtered on the dashboard.

Active directory is way too slow, and I am using DirectQuery.

[mahoneypat]

If the Active Directory connector didn't work, you could also pursue making an API call to the Microsoft Graph (not easy as it requires your tenant admin to register an Azure app and give permissions, etc.).  I usually get it outside of Power BI (possibly using a Flow), refresh it monthly or so and put it into a Dataflow so it is available for multiple models.

Pat

[vladimir84]

For now, I'm using the SharePoint solution from here. 

I need something that I don't need to refresh and store (this would open issues with data retention and updating it to fresh data).

In powerApps it's easy, just add a column with the connector and you have the table on the fly.