Forum Discussion

mmace1's avatar
mmace1
Impactful Individual
4 years ago
Solved

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

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? 

Need Help
  • edhans's avatar
    edhans
    4 years ago

    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.

     

1 Reply

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    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.