Forum Discussion

MattieG72MP's avatar
MattieG72MP
Advocate I
8 years ago
Solved

Two Data Sources - On Premise and Azure?

Hi All We have an on-premise gateway and it works very well for all of our service reports but I now need to add Azure Database data to some of these reports. Is there any option in the service to ...
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi MattieG72MP,

     

    I tested it successfully with import mode to local SQL DB and Azure SQL DB. Please try it out.

    Two_Data_Sources_On_Premise_and_Azure

     

    Best Regards,

    Dale

bwhitlocksaxco's avatar
bwhitlocksaxco
Frequent Visitor
8 years ago

I dont understand the resolution on this. Im having the same requirement. I have an on premise gateway that Im merging data from a local SQL db and an Azure DB. My current gateway refreshes every day but I dont see an option to add the Azure DB to the gateway. Do you have to dump the Azure DB to local tables then use that table in the gateway? If so how is that done.