Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
EraDon
Frequent Visitor

Power BI Active Directory connection

Hi,

 

 I have connected AD to the Power BI desktop to import all users and computer details but I cannot get data from the on-premises gateway. Could someone give a guide or documentation on how to set up the gateway for AD connection?

When I try to connect using gateway manager, throws an error with an incorrect credential. I am not sure do we need to have a special AD account with some permission to get data through the gateway. 

On desktop connection, I use my domain account and there is no issue importing the data.

 

Kind Regards

Eranga

 

2 REPLIES 2
v-xiaoyan-msft
Community Support
Community Support

Hi @EraDon ,

 

Did you try to add AD as a data source to the gateway?

 

vcaitlynmstf_0-1658479633972.png

 

You may refer to Power BI Data Gateway with Active Directory 

 

Best Regards,
Community Support Team _ Caitlyn

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

Hi Caitlyn,

 

 I can see you have the Azure Active Directory set up in the gateway. But I used normal on-premises AD.

Do I need to use Azure AD for the gateway? 

Secondly, you use the powerbi user account to connect. does it have special permission? I used my credential and I have the right to view and add computers and users to AD.

 

Other than that, I followed the same steps.

 

Kind Regards

Eranga

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors