Thu Sep 19 08:22:55 UTC 2024: ## On-Premises Data Gateway Version 3000.238.11 Released, Enhances Data Integration for Power BI

**Redmond, WA – September 2024** – Microsoft has announced the release of the on-premises data gateway version 3000.238.11, a key update that enables users to seamlessly integrate on-premises data sources with Power BI Pipelines using the Copy Activity. This significant milestone expands Power BI’s data integration capabilities, allowing users to leverage on-premises data within their business analytics workflows.

The new gateway version also addresses a critical issue related to connecting to SQL Servers using self-signed certificates. Previously, refreshes of Fabric semantic models or dataflows could fail due to trust issues. This release includes solutions for both the on-premises data gateway and Power BI Desktop, enabling users to configure trust for SQL Servers and ensure successful connection and data refresh.

**Key Enhancements:**

* **Support for Copy Activity with on-premises sources:** Leverage on-premises data in Power BI Pipelines.
* **Improved SQL Server Connectivity:** Resolved issues with self-signed certificates, ensuring reliable data refreshes.
* **Gateway alignment with Power BI Desktop:** The new gateway version aligns with the September 2024 release of Power BI Desktop, ensuring consistent query execution and runtime.

**Addressing Trust Issues with SQL Servers:**

To prevent connection errors caused by self-signed certificates, the release provides specific steps to configure trust for SQL Servers using both the on-premises data gateway and Power BI Desktop. Users can modify the gateway configurations and environment variables to establish trust and enable successful data connectivity.

**Power BI’s Continued Evolution:**

The on-premises data gateway release reflects Power BI’s ongoing commitment to providing robust and scalable data integration solutions. Users are encouraged to continue sharing feedback and feature suggestions on the Power BI Ideas forum, contributing to the future development of this powerful business analytics platform.

**About Power BI:**

Power BI is a comprehensive suite of business analytics tools that empower users to analyze data, share insights, and create interactive dashboards accessible from any device. By leveraging the power of data, businesses can gain valuable insights, monitor performance, and make informed decisions.

Read More