Forum Discussion

CKM_Comptrac's avatar
CKM_Comptrac
New Member
5 years ago

Consolidate Data Table from Different Gateways

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.

Dataflow
Show and Tell
Tips and Tricks

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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