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
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Restore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch30 minutes agoNew MemberNew81Views9likes2CommentsReturn .png Attachments to Subscriptions
With the latest update to Power BI subscriptions, the separate .png report snapshot attachment has been removed. From Microsoft’s troubleshooting documentation, this appears to be an intentional chan...KDC_Group_PBI34 minutes agoNew MemberNew220Views23likes8CommentsAutomatically process calculated tables after semantic model deployment through Git integration.
We have a composite semantic model containing DirectQuery tables and calculated tables stored in Import mode. The semantic model and its associated reports work as expected in the development worksp...Manojkumar2940 minutes agoMicrosoft EmployeeNew14Views5likes0Comments