microsoft fabric
2 TopicsLocal 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.Solved418Views1like4CommentsData Wrangler Aggregation does not work properly for Spark Data Frames
Hi Team, When we are creating a Spark Data Frame and open Data Wrangler and if we try to add "Group by and aggregate" operation under "aggregation" section when we select a particular column it does not show all the aggregation options for the selected column. It just shows 5 aggregations i.e. count, first value, last value, number of distinct values and mode. I think this is a bug. I hope you are able to understand the issue.Solved1.3KViews0likes2Comments