How to get the data from on premise SQL to Power BI

[Anonymous]

Hi All,

I am facing an issue, trying to get the data from on premise SQL to Power BI using Gateway.

Can anyone please suggest the gateway configuration steps, also additional configurations like port enable, inbound outbound traffic settings.

If anyone already has done this functionality please help me with this.

[v-yuta-msft · Accepted solution]

@Anonymous ,

If you don't know how to install and configure gateway on your server, I would suggest you follow steps in official doc below:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app

However, if you get stuck on some issues, please clarify more details about the issue and what you have done before this issue happens.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

What kind of issue are you facing?
You could also check out the links below and see if they are of any help

Refresh data from an on-premises SQL Server database 

Power BI - On-Premises Data Gateway 

What is an on-premises data gateway?