Get Data from Active Directory

[spdevInnoventix]

Hello All,

Thanks in advance!

I would like to connect all the users data from My Active Directory to Power BI is there any way to do that because whenever I try to connect the domain it fails to connect and says domain not found.

[AnetaK]

Do I need to have any special rights granted (admin or sth)?

Can I be a regular AD user?

[pfarias]

This discussion is old but the subject is no. So just to leave a solution here, ideally you will use the Microsoft Graph REST API.

To access Active Directory Online data, the API will be able to access all data from both AD and even Shrepoint Lists and other information. It is with it that you will even be able to manipulate data from AD or Sharepoint.

Documentation Microsoft Graph

[v-stephen-msft]

Hi @spdevInnoventix ,

You can connect to Active Directory from Power  BI Desktop following the instructions in this blog, load user table and computer table into Desktop.

In addition, here is similar thread about how get AD attributes in Power BI for your reference.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spdevInnoventix]

Thanks @v-stephen-msft 

When I used this blog and try to connect domain name which I got from portal.azure.com it shows that domain doesn't exists.
My domain name - xyzmydmain.onmicrosoft.com

[v-stephen-msft]

Hi @spdevInnoventix ,

I think your domain name may be wrong, please follow the steps below to check your own domain name.

1. From the “Administrative Tools” menu, select “Active Directory Domains and Trusts” or “Active Directory Users and Computers“.
2. Right-click the root domain, then select “Properties“.
3. Under the “General” tab, the “Domain name”  is displayed on the screen.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spdevInnoventix]

I am using online version of Active Directory so in my case this won't help me.

[v-stephen-msft]

Hi @spdevInnoventix ,

Does online version of Active Directory refer to Azure AD? You may check domain from this:

Find tenant ID, domain name, user object ID - Partner Center | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spdevInnoventix]

I tried but same not able to connect

[Gabriel_Walkman]

What connector did you try, and what url? You can replace company name etc. with something generic in the url if you want to anonymize it for us to see.

What does "all data" contain?

[spdevInnoventix]

Thanks for your reply,

I tried my luck with this thread - https://community.powerbi.com/t5/Desktop/Get-Data-Active-Directory/td-p/73726

But I didn't want to execute any function what i want is direct query so I tried with Azure AD connector.

Also for me Microsoft Graph connector is not visible, I don't know why.