Within Fabric SQL databases you can cross-database query in the warehouse connection.
However cross-database querying from one live SQL database to another is not possible.
It would be great to have this possibility with 3-part names: select* from [sqldatabase].[dbo].[table_A]
By getting this migrating from on-prem SQL server or an Azure managed instance to Fabric will be easier.
1 Comment
- Status added:Under Review
Recent ideas
Fabric REST API endpoint for dataflow transactions should GET *sortable* results for a time-range
Dataflow refresh APIs seem to be the buggiest; the list of transactions on a GET for Fabric-dataflow, are not sorted by the latest. OData query options such as $top, $filter, $orderby do not work wit...
