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

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