This article describes the process of connecting to on-premises data using Microsoft Fabric Lakehouses. To accomplish this, a data gateway must be installed on the user's machine. Microsoft Fabric supports numerous on-premises and cloud data sources, all with varying requirements. The article outlines how to connect an Azure SQL Server as a cloud data source, and notes that similar steps can be followed for other sources.
Despite still being in preview, Microsoft Fabric offers a robust set of functionalities for managing and manipulating data. This includes pipelines and Kusto with plans to extend to other items. Personal cloud connections can be created in datasets, datamarts and dataflows using Power Query Online in the "get data" function.
To manage user access, assigning users and security groups to data sources is necessary. Each data source has different user lists, so users should be assigned to each relevant source. This list only determines who can make use of the data source in related items.
In managing data sources, users can be added or removed in the "Manage Users" tab. Users should remember they need to add users for each data source they wish to give access to. When it comes to access levels, there are three roles to choose from: User, User with resharing, or Owner. If a user or security group no longer requires access to a data source, they can be removed from the access list in the data source settings.
This text is about how to connect to on-premise data in Microsoft Fabric. It begins by explaining how to connect and visualize your on-premise data using Microsoft Fabric Lakehouses. The text states the importance of having a data gateway installed on your machine to load your on-prem data to the cloud into Fabric. It further explains that Microsoft Fabric supports many on-premise and cloud data sources, each source having its own requirements. It mentions that this information relates to a prerelease product that might be modified before it's released. The end of the excerpt begins to describe how to select Manage connections and gateways in Microsoft Fabric and add a new data source.
Microsoft Fabric data connection guide, Microsoft Fabric on-premises data visualization, Setting up data gateway for Microsoft Fabric, Connect to Azure SQL server using Microsoft Fabric, Privacy level configuration in Microsoft Fabric