Consolidate Data Table from Different Gateways

[CKM_Comptrac]

I have created DataView with same  structure in   different country database.  

SGData(Country,Year,Month,TotalSales,CustomerName) 

MYData(Country,Year,Month,TotalSales,CustomerName) 

CNData(Country,Year,Month,TotalSales,CustomerName) 

I have a DataTable (AllCtryData)  which is  Union of  SGData and MYData. They are residing on different servers, but in same network. So I manage to  append the data. However, CNData is  residing in China and  I have created a gateway. But I am not sure how to consolidate (CNData) to AllCtryData  in Power BI Services.  

I can create  two Reports on is SG+MY  Sales Report and  CN Sales Report. But if possible I would like to combine all three countries.  

Is there any way to achieve that ? 

Thanks in advance.

[v-easonf-msft]

Hi， @CKM_Comptrac

You do not need to create two reports and two gateway to refresh them.

You only need to create a report connected to these three databases. After publishing the report to the service, you only need to add theses data source  to the same gateway and configure the crendentials.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hello @CKM_Comptrac ,
If each data source must be added in the same gateway.
You can refer to this link