Forum Discussion

NerdFlanders's avatar
NerdFlanders
Advocate I
9 years ago

Gateway refresh active directory and SQL

HI,   I have a datamodel which gets data from an SQL on-prem Server and on-prem active directory.    Is it possible to setup a data refresh with the Power BI Enterprise Gateway? Even if it's only...
Need Help
Edwin_PBi's avatar
Edwin_PBi
Regular Visitor
9 years ago

NerdFlanders, did you get any solution for this? we have the same issue with Oracle and Active Directory.

robofski's avatar
robofski
Resolver II
9 years ago

I think the issue here is that you can't setup a Gateway datasource for Active Directory and unless all data sources in the dataset can use the Gateway then the gateway option is not available.  I've got datasets that get data from On Prem SQL and On Prem Excel files and they work just fine but only after I had created all the connections.  Failed to create one of the sources in the gateway and the option wasn't available.

 

I too have a dataset using Active Directory as the source and I can't schedule a refresh of it, really disappointing.  I'm considering having a job run on prem to extract the AD data and then use the extract as my data source, not as great as I'd like but this is only requires a daily refresh so it's probably a workaround.