Accessing external server

[smpa01]

@AntrikshSharma @AlexisOlson 

How can I use T-SQL OPENDATASOURCE/OPENROWSET between two different AZURE SQL servers (stemming from 2 diiferent datamarts) to facilitate cross-server query

In db2 I am doing this and It is not working

SELECT 
  * 
FROM 
  OPENDATASOURCE(
    'SQLNCLI', 'Data Source=blahblahblah.datamart.fabric.microsoft.com;Integrated Security=SSPI'
  ).db_powerbiprodnam_xxxx_yyyy_zzzz.model.dim_country //.db.schema.table 

SELECT 
  * 
FROM 
  OPENDATASOURCE(
    'MSOLEDBSQL', 'Server=blahblahblah.datamart.fabric.microsoft.com;  Database=db_powerbiprodnam_xxxx_yyyy_zzzz;TrustServerCertificate=Yes;Trusted_Connection=Yes;'
  ).model.dim_country 

SELECT 
  * 
from 
  OPENROWSET(
    'SQLNCLI', 'Server=blahblahblah.datamart.fabric.microsoft.com;Trusted_Connection=Yes', 
    db_powerbiprodnam_xxxx_yyyy_zzzz.model.dim_country
  ) as d

Thank you in advance.

[AntrikshSharma]

I think @lbendlin might be the right person for this.

[lbendlin]

I am not aware of a cross server query option

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical?vi...