Join two tables from different instance in one Dashboard

[Kri]

I want to join two tables from 2 different instance in a dashboard. Is there a way I can achieve this requirement?

I have table1 in instance1
I have table2 in instance2

I want to create a dashboard in instance1 which should show the fields from table1 in instance1 and table2 in instance2

[Hitoshi Ozawa]

Probably would need to import table2 from instance2 to instance1 and then show the imported table.

If there's not much records in table2, maybe use REST API to retrieve. However, this approach isn't too good because the REST API would require being called each time dashboard is displayed. If table2 is being updated frequently and it's required to refresh the dashboard to show updated table, this may cause performance issues.

[Kri]

Both instance contains different users from different region. One region users shouldn't see the other region user records but for the internal purpose I require a dashboard that should combine both the table in one instance

[Hitoshi Ozawa]

Disallowing users from seeing content of a table is a matter of setting ACL properly. Just set the ACL so only users who require it to see for internal purpose have read permission.

[Kri]

.