Forum Discussion

Angel's avatar
Angel
Resolver III
8 years ago
Solved

Merge tables multiple servers (using ODATA)

Hi, everyone   The scenario is this: Two tables in two databases from two different servers (Table 1 and Table 2). I have used ODATA to connect with datas (ODATA Table1 and ODATA Table2). I hav...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Angel,

    You would need to create a single PBIX file, and connect to the two OData source in this PBIX file, and you can use merge queries feature in Desktop to merge the tables.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Angel,

Firstly, you can use only one on-premises gateway to refresh your datasets, just make sure that you are able to access the two OData data sources from the machine that installing gateway.

Secondly, it is not possible to merge tables at Power BI Service side. We are only able to merge tables in Power BI Desktop.

Regards,

Lydia

Angel's avatar
Angel
Resolver III
8 years ago

Hi, Anonymous

 

Thanks for your quick response...

 

Does anyone knows how can i solve the issue to merge tables from different servers???.

 

Is it posible in some way??..

 

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Angel,

    You would need to create a single PBIX file, and connect to the two OData source in this PBIX file, and you can use merge queries feature in Desktop to merge the tables.

    Regards,
    Lydia