How To Connect To On-Premises Data In Microsoft Fabric
Microsoft Fabric
Sep 8, 2023 5:00 AM

How To Connect To On-Premises Data In Microsoft Fabric

by HubSite 365 about Pragmatic Works

Data AnalyticsMicrosoft FabricLearning Selection

Learn how to effortlessly connect and visualize your on-premises data using Microsoft Fabric Lakehouses. Discover the seamless process of establishing a secure

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.

  • The "Settings" icon in the Microsoft Fabric service is used for managing connections and gateways.
  • To add a new data source, select "New" in the Connections tab. Provide necessary information about the data source and choose an authentication method. Note that cross-tenant Azure Active Directory accounts aren't supported.
  • If the connection is successful, a message indicating "Created new connection" appears under Settings.
  • If a data source is obsolete, it can be removed by selecting it and then clicking "Remove".

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.


Managing Data Sources In Microsoft Fabric Lakehouses


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.

Learn about How To Connect To On-Premises Data In Microsoft Fabric


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.


More links on about How To Connect To On-Premises Data In Microsoft Fabric

Data source management - Microsoft Fabric
May 23, 2023 — From the page header in the Microsoft Fabric service, select the Settings icon, and then select Manage connections and gateways. Screenshot ...
Getting on-premises data into Microsoft Fabric using the data ...
Aug 1, 2023 — Click on the manage connections and gateways link and add your data gateway. But, the gateway in itself is empty. What you need are connections.
Microsoft Fabric, connect data pipeline to onpremise source
Jun 16, 2023 — I am working with microsoft fabric and I need to create a data pipeline to extract information from a folder located on an onpremise server, but ...
Microsoft Fabric: Loading On-Premises and External Data
Aug 28, 2023 — If the data is located on-premises or in a network we don't have direct access to, we can use what's called a self-hosted integration runtime.
Microsoft Fabric: Integrate your data into the Cloud
Aug 24, 2023 — How to use Microsoft Fabric On-Premises Data Gateway to securely transfer your on-premise data to the cloud.
Gateways to On Premise : r/MicrosoftFabric
May 25, 2023 — Under the Pipeline creation wizard for Copying data into Lakehouse, when selecting SQL Server, you do not get the option to select a gateway.
Getting On-Premises SQL Server Data to Fabric Lakehouse
Aug 15, 2023 — We click on the little gear icon against the Destination, this opens a new window where you just select Next with the Lakehouse selected as a ...


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