In today’s blog post, we’ll walk you through the process of setting up and utilizing the on-premises data gateway for Microsoft Fabric, specifically for Power BI. Let’s dive in and explore how you can seamlessly connect your on-premises data sources to the cloud with the on-premises data gateway.
Why Use an On-Premises Data Gateway?
The on-premises data gateway is essential for connecting your on-premises data sources to various Microsoft services. If your data resides on a machine within your office or data center and is not accessible from the cloud or internet, the gateway becomes your bridge to accessing and leveraging this data in Power BI and other Microsoft Fabric services.
For example, if you have an on-premises SQL Server (like SQL Server 2022), you can use the gateway to integrate this data into your Power BI reports or other components of Microsoft Fabric. The gateway supports a wide range of services including Azure Analysis Services, Power Apps, Power Automate, and Azure Logic Apps, making it a versatile tool for various data integration scenarios.
Setting Up the Gateway
Step 1: Download and Install the Gateway
- Navigate to the Microsoft Fabric workspace: Start by uploading your report and dataset, which should include data from your on-premises sources.
- Access the Download Option: In the Home section, select the “Download Data Gateway” option. You can choose between the standard mode (enterprise gateway) and the personal mode. For most production scenarios, the standard gateway is recommended as it supports more services beyond just Power BI.
3. Install the Gateway: After downloading, run the installer and follow the prompts to accept the terms and install the gateway.
Step 2: Configure the Gateway
- Sign In and Register: Once installed, sign into the Microsoft Fabric service to configure the gateway. You can either register a new gateway or manage an existing one.
2. Naming and Clustering: Give your gateway a name. You can add it to an existing gateway cluster or create a new one. Clusters help manage multiple physical gateways, enhancing load balancing and reliability.
3. Set a Recovery Key: This key is crucial for future migrations or restores. Ensure you remember this key.
Post-Installation Configuration
- Manage Gateway Settings: After configuration, manage your gateway through the Microsoft Fabric service. You can adjust settings such as service accounts, diagnostics, network port tests, and recovery keys.
- Assign Data Sources: Add your on-premises data sources to the gateway. For example, configure connections for SQL servers or local file paths ensuring network connectivity is established between the gateway and data sources.
- Refresh and Validate: After setting up, go to your dataset settings in Power BI, map it to the gateway, and test the connection. A successful refresh indicates the gateway is correctly configured and operational.
Using the Gateway
Once configured, the gateway can be used to refresh datasets in Power BI, access on-premises data, and create shortcuts to external data sources such as Amazon S3 or Google Cloud Storage.
Example: Creating a Shortcut to Amazon S3
- Go to your Lakehouse in Microsoft Fabric.
- Create a new shortcut and select Amazon S3.
3. Enter the S3 URL, connection name, and select the configured gateway.
4. Provide the access key for the S3 bucket.
5. Choose the folder containing your data and create the shortcut.
6. You can now access your data in Amazon S3 through Microsoft Fabric using the configured gateway.
Conclusion
Setting up an on-premises data gateway expands the versatility and reach of your data integration efforts in Microsoft Fabric and Power BI. With this gateway, you can seamlessly connect on-premises data sources, ensuring comprehensive and efficient data management.
For more detailed guidance and in-depth training, visit our training page here.
