Active Directory as Datasource and On-Premise Data Gateway

[Anonymous]

I've used Active Directory as my only data source in my Power BI project and i've attempted to add this same data source into the On-Premise Data Gateway.   There is a data source type also called 'Active Directory' in there.  Using the same connection settings, the gateway fails with a 'DataSource.NotFound'.  Is there a trick to this?

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Active Directory is not a supported data source for refresh.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshoot-unsupported-data-source-for-refresh/

Regards,
Lydia

[Anonymous · Accepted solution]

Thanks Lydia ( @v-yuezhe-msft ).

What does this connect to then?
(Taken from Add Data Source in Manage Gateways)

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Active Directory is not a supported data source for refresh.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshoot-unsupported-data-source-for-refresh/

Regards,
Lydia

[Anonymous · Accepted solution]

Thanks Lydia ( @v-yuezhe-msft ).

What does this connect to then?
(Taken from Add Data Source in Manage Gateways)

[v-yuezhe-msft · Accepted solution]

@Anonymous,

I guess the feature that supports refresh for Active Directory data source is under development, and the ActiveDirectory option is added in the source list.

Regards,
Lydia

[Anonymous]

Any news on this being available?

[Tsanka]

Hi guys,

Are there any news on this? 

Is there any way to have scheduled refresh on AD datasource?

Thanks

[mjmmet]

 I have been refreshing my Active Directory data source on a schedule since January and exactly 3 months after setting it up, it stopped working  with error  Invalid connection credentials error.  tried updating the on prem data gateway and resetting the password on the account that runs it.

Is anyone else refreshing Active Directory data source successfully?  it was previously working for me

[NMAN47]

@mjmmet Have you had any luck with the AD gateway yet? Did you get it to work now? I can't even create a data source to AD.

[Anonymous]

It works for me when using Dataflows

[Tsanka]

My workaround is with a SSAS model, the refresh of the AD related queries is done with no issues there.