Gateway refresh active directory and SQL

Question

HI,&nbsp;I have a datamodel which gets data from an SQL on-prem Server and on-prem active directory.&nbsp;&nbsp;Is it possible to setup a data refresh with the Power BI Enterprise Gateway? Even if it's only updating the data from the SQL servers would be enough for now.&nbsp;Thanks in advance!

robofski · Answer

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.&nbsp; 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.&nbsp; Failed to create one of the sources in the gateway and the option wasn't available.&nbsp;I too have a dataset using Active Directory as the source and I can't schedule a refresh of it, really disappointing.&nbsp; 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.

tringuyenminh92 · Answer

Hi NerdFlanders,Yes, you can. On-premise gateway pbi is for that. Just install enterprise gateway in your server, sign in with account and verify credential for the first time in pbi service. Refreshing schedule could be done in pbi service (web) if you are using import mode for data model.. Please refer https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/. If have any concern please let us know to help you.

nerdflanders · Answer

Hi&nbsp;tringuyenminh92,&nbsp;thanks for you reply.Unfortunately it's not working. I have 7 SQL databases and an Active Directory connection in the report. All SQL servers are registrered in the PBI Gateway, but on the PowerBI website it can't find the Gateway, so I can't setup a refresh.

tringuyenminh92 · Answer

Hi&nbsp;NerdFlanders,&nbsp;From your server, please run Enterprise gateway and sign in to ensure it's running. After that, open browser and sign in PBI, go to Datasets tab of reports to check if there is any gateway instance available or not?Hope you could share your screenshots of your Manage gateways screen and your Datasets of reports screen as below pictures:

nerdflanders · Answer

Hi&nbsp;tringuyenminh92&nbsp;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.&nbsp;I have the same problem with Excel in OneDrive and SQL, its just not working together when you want to setup a scheduled refresh.

Forum Discussion

Gateway refresh active directory and SQL

8 Replies

Related content

PBI Gateway failing on scheduled refresh

Model Refresh Errors after June 2026 Gateway Upgrade Resolved Themselves?

Gateway data refresh error

Refresh failure: Cloud data source refresh is not allowed in gateway setting

Power BI gateway refresh error