On Prem Data Gateway

[srinival]

Hi Team,

We have a On Prem SQL Server which is acting as Data Source for which we use Import functionaity, we use a On Prem Gateway Standard Edition for publishing the data to Service.

Our Company wants to move the On Prem SQL Server and On Prem Gateway to Azure / AWS Cloud.

I have few clarifications in this regard.

Do we require on On Prem Gateway when our servers are moving to Cloud.

Please do share me any documentation if we are moving the Gateway to Cloud 

Thanks and Regards

Srini

[StefanoGrimaldi · Accepted solution]

depending on the source type and configuration you dont requeire a gateway at all to connect to cloud base sources, read these:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-cloud-data-sources

it will give you a better notion depending on witch its your case exactly. 

[srinival]

Hi All,

Thanks for the clarifications provided, I was using Standard Gateway as our data source is still in On-Premise and we just moved our On Prem gateway to Cloud.

I have not encountered any issue after it was migrated.

Regards

Srini

[v-tangjie-msft · Accepted solution]

Hi @srinival ,

Datasets that use cloud data sources, such as Azure SQL DB, don't require a data gateway if Power BI can establish a direct network connection to the source. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.  Accordingly, you can manage the configuration of these data sources by using the Data source credentials section in the dataset settings.

While cloud data sources don't necessarily require a gateway, a gateway is required if a dataset connects to both on-premises and cloud sources in a single mashup query.

You can refer to the following documents: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-cloud-data-sources

Best Regards, 

Neeko Tang 

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

[StefanoGrimaldi · Accepted solution]

depending on the source type and configuration you dont requeire a gateway at all to connect to cloud base sources, read these:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-cloud-data-sources

it will give you a better notion depending on witch its your case exactly.