Microsoft has recently released an important update for their On-Premises Data Gateway this October 2023. This update, dubbed version 3000.190.17, brings about several changes and enhancements that users have been looking forward to.
A notable highlight of this update includes a new PowerShell cmdlet, which will aid in adding a gateway to an existing cluster. This function is particularly useful for managing gateways in the cloud environment.
Also, the on-premises data gateway will now be in sync with the October 2023 release of Power BI Desktop, providing users with consistent query execution logic. Data managing system will be seamless regardless of the platform.
To make the most of the new PowerShell cmdlet, your gateway version must be beyond `3000.162.9` (Feb 2023), and it requires PowerShell 7 or higher. The introduction of new cmdlet gives you the ability to programmatically add a gateway to an existing cluster on any machine where you have admin permissions. For more information and guidelines, refer to Microsoft's online documentation.
Addition of new gateway to an existing cluster follows a simple process. First, you must install the DataGateway module, then proceed to login to the gateway as an administrator. Lastly, existing cluster addition can be executed by adding a new gateway.
You'll have to provide three parameters; GatewayName (string), RecoveryKey (Secure string), and GatewayClusterId (Guid). These entries would then be used for encryption/decryption by the gateway for on-prem credentials.
Example prompts for these tasks have been provided in the release notes for both creating and registering a new gateway, as well as securely storing the encrypted recovery key.
In another notable change, users of the SAP ERP connector in Power Apps and Power Automate will need to upgrade the SAP NCo library from 3.0 to 3.1 to ensure compatibility with the new on-premises data gateway. Failing to upgrade might lead to the malfunctioning of connections and flows.
SAP Connector for .NET 3.0 (NCo 3.0) allows developers to utilize BAPIs and remote-enabled function modules in any .NET application, marking a significant step toward enhanced flexibility for developers.
Lastly, tracking of artifacts such as dataflows and datasets have been made easier, thanks to the inclusion of Artifact Ids in logging. The new improvements render enabling additional logging unnecessary for Artifact Id access.
With the arrival of this October 2023 release, Microsoft continues to be committed toward enhancing user experience and functionality of their On-Premises Data Gateway. They encourage users' feedback and suggestions for future improvements, thus promoting a user-first approach to technology.Read the full article On-premises data gateway October 2023 release
Welcome to October! I am here to share significant announcements for October 2023 revolving around the on-premises data gateway (version 3000.190.17). This release introduces crucial updates that will be beneficial to anyone dealing with data management and various Microsoft systems.
You'll be delighted to hear about our highly anticipated PowerShell cmdlet that can add a data gateway to an already existing cluster. But before we delve into the details, let's quickly cover some basics.
For those unaware, a data gateway acts as a bridge that provides secure and quick data transfer between on-site data, like SQL Server, SharePoint, and others and cloud-based services such as Power BI, Power Apps, Logic Apps and more.
This updated version of the gateway thereby aligns with the October 2023 release of Power BI Desktop, ensuring your published reports via the gateway go through the same query execution logic/run-time as in the October version of Power BI Desktop.
We are thrilled to introduce a new cmdlet to our DataGateway PowerShell cmdlets, primarily designed to programmatically add a gateway to an existing cluster. This cmdlet could prove extremely useful when managing gateways in the cloud.
Before using the cmdlet, make sure your gateway version is `3000.162.9` (Feb 2023) or higher. These cmdlets need Powershell 7 or higher. For more information, please check our online documentation which includes appropriate installation guidelines.
Adding a new gateway to an existing cluster involves four steps:
A critical message to the SAP ERP USERS: The October release of the on-premises data gateway compels an upgrade of the SAP NCo library from 3.0 to 3.1 to certify compatibility. If the upgrades are not executed at the same time, connections and flows will fail, please note that.
Each SAP Connector for Microsoft .NET 3.0 (NCo 3.0) authorizes developers to utilize BAPIs and remote-enabled function modules in any .NET application (inside-out). Equally, you can access .NET components from any ABAP application by putting into operation an RFC server in .NET (outside-in).
We have made it easier to track artifacts like dataflows and datasets by adding related information to the logs. For this improvement, update to the June 2023 version or later.
In conclusion, your feedback is tremendously important to us. Continue providing us with your insights on which capabilities you'd like to see in the future! Please vote for your favorite feature suggestions at Ideas (powerbi.com).
On-premises data gateway, October 2023 release, Data Gateway 2023, Latest Data Gateway Release, On-Premises Gateway Update, Data Gateway October Update, October 2023 On-Premises Gateway, 2023 Data Gateway Release, New On-Premises Gateway Release, October 2023 Data Gateway