Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

Unlocking the Power of On-Premises Data Gateway for Microsoft Fabric and Power BI

Filters

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
  1. Navigate to the Microsoft Fabric workspace: Start by uploading your report and dataset, which should include data from your on-premises sources.
  2. 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.

Download and Install the Gateway On-Premises Data Gateway

          3. Install the Gateway: After downloading, run the installer and follow the prompts to accept the terms and install the gateway.

Install the Gateway on-premises data gateway

Step 2: Configure the Gateway
  1. 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.

Sign In and Register

   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.

Naming and Clustering

 3. Set a Recovery Key: This key is crucial for future migrations or restores. Ensure you remember this key.

Set a Recovery Key on-premises data gateway

Post-Installation Configuration

  1. 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.
  2. 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.
  3. 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.

Post-Installation Configuration

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
  1. Go to your Lakehouse in Microsoft Fabric.
  2. Create a new shortcut and select Amazon S3.

Creating a Shortcut to Amazon S3

3. Enter the S3 URL, connection name, and select the configured gateway.

4. Provide the access key for the S3 bucket.

Amazon S3

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.

Leave a Comment

Your email address will not be published. Required fields are marked *