Create Gateway

Please follow https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install in order to install on-premises data gateway on the target SQL server(s). Note when adding multiple gateways to a cluster, all gateway nodes must be always online to ensure performance is not impacted. Also note that when removing a cluster, you must manually uninstall the on-premises gateway from each server before it will allow you to remove the gateway from the web portal.

Navigating to "Settings" and "Manage gateways"

Visit https://app.powerbi.com/home and click the gear symbol followed by Manage gateways.

Adding yout data source information from the application created previously

Select the gateway you installed on the SQL server earlier followed by selecting Add Data Source and specify the Data Source Name, Data Source Type, Server, Database, Authentication Method, Username, Password and click Apply.

 

 

Previous article: Configure Workspace

Next article: Configure Gateway

Updated on December 2, 2021

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment