Forum Discussion
Gateway refresh active directory and SQL
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.
Hi tringuyenminh92,
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.
Hi NerdFlanders,
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:
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.
