Forum Discussion
Gateway refresh active directory and SQL
Unfortunately i can't post pictures because the gateway is administrated by our Admin and he won't allow me to post pictures here, but I can ensure that the gateway is running, because the refresh of other reports is running properly and i tried to deploy this report without the active directory connection (only SQL server connections), then it worked. When I added the Active Directory connection again it couldn't find the gateway anymore. So it seems that I can't mix two different connection types in a report.
I have the same problem with Excel in OneDrive and SQL, its just not working together when you want to setup a scheduled refresh.
NerdFlanders, did you get any solution for this? we have the same issue with Oracle and Active Directory.
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.
Edwin_PBi Unfortunately not. I also didn't continue working on this report.
It's really nice that PowerBI offers a lot of data connectors, but if I can't use 2 diffent ones together it's a big issue they should work on.
