Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful 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...
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.

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity 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.