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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi MattieG72MP,

 

You can use the Azure database directly. Is it a Azure SQL Server Database? You can try it out and post the issues you have.

 

Best Regards,

Dale

MattieG72MP's avatar
MattieG72MP
Advocate I
8 years ago

Hi All

Basically what I am trying to achive in the service is having a report that pulls data from the on-premise gateway and also from Azure but as far as i can see there is no way of setting up the 

dataset subscription to come from an on-premise gateway and a direct connection to Azure?

 

Thanks

Mattie

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi MattieG72MP,


      Could you please mark the proper answer as solution?

       

      Best Regards!
      Dale