ssms
1 Topic
Local SQL Server unable to retrieve data from Microsoft Fabric Lakehouse through SSMS
Hi everyone, I am able to successfully connect to a Microsoft Fabric Lakehouse from SSMS. I also have a local SQL Server instance running on localhost. However, the issue is that my local SQL Server connection is unable to retrieve/load data from the Fabric Lakehouse connection. Scenario: Fabric Lakehouse connection works in SSMS Localhost SQL Server connection also works separately But I cannot pull Fabric data into local SQL Server tables I would like to understand: Is direct data transfer between Fabric Lakehouse and local SQL Server supported through SSMS? Can stored procedures or queries in localhost SQL Server access Fabric Lakehouse tables? Are linked servers, external tables, gateways, or any additional configurations required? What is the recommended approach for loading Fabric data into local SQL Server tables? My objective is to validate large-volume data movement between the source and local target tables. Any guidance would be appreciated.Solved418Views1like4Comments