Merging Azure SQL Table with a local SQL Server Table - now Azure one needs Data Gateway?

[mmace1]

I have two tables. 

AzureSQL_Table1
SQLServerLocal_Table1

If I upload my dataset, then to refresh from the service, I need a data source in the data gateway for SQLServerLocal_Table1, but not AzureSQL_Table1.

That's expected behavior.

• On premises source needs data gateway.
• Cloud source does not.

If I merge in one column fromSQLServerLocal_Table1, onto AzureSQL_Table1, then suddenly the Azure SQL source is asking for an entry in the data gateway. 

Is that because the merge will happen on the gateway, not the service, or? 

[edhans · Accepted solution]

Yes. When you mash up data (merge, append, etc) cloud and on prem data, you need to allow the gateway to access those cloud data sources as shown below from the gateway config in the Power Platform admin panel. 

If you are just pulling in the tables directly and not merging, this would not be necessary.