Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

lrtoyou1223
Microsoft Employee
‎03-23-2026 09:00 AM

PowerShell Module for Gateways with Expanded Automation Capabilities (Generally Available)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

The PowerShell module for gateways delivers a fully supported, enterprise-ready command surface for managing on-premises data gateways and VNET data gateways through automation and scripting.

Now, the gateway PowerShell module moves beyond preview into production-grade support, with stronger command coverage, improved reliability, and expanded lifecycle management scenarios. Organizations can now confidently adopt PowerShell-based gateway management for large-scale, regulated, and mission-critical environments.

What it means for administrators and enterprises

This milestone represents more than feature completeness—it signals that the PowerShell model is ready for broad production use with:
  • Full production support
  • Stable and validated command behaviors
  • Broader lifecycle coverage
  • Improved error handling and reliability
  • Better alignment with enterprise automation and DevOps workflows
IT teams can now standardize gateway operations using scripts and automation pipelines instead of relying on manual UI-driven steps.

Screenshot_of_commands_from_the_Gateway_PowerShell_module_used_to_manage_and_monScreenshot_of_commands_from_the_Gateway_PowerShell_module_used_to_manage_and_mon

Figure: Using the Gateway PowerShell module to manage gateway operations from the command line.

New PowerShell commands

This release adds several new commands that significantly expand update control, version visibility, and recovery capabilities.

Update-DataGatewayClusterMember — Trigger gateway member updates when a newer version is available.

New parameters:

  • TargetVersion — Update to a specified gateway version
  • CheckStatus — Retrieve the latest update status for tracking progress
Get-DataGatewayAvailableUpdates — Retrieve the latest six available gateway versions to support upgrade planning.

New parameters:

  • GatewayClusterId — Check versions available for a cluster
  • MemberGatewayId — Check versions for a specific gateway member
If no versions are returned, the gateway is already up to date — making this a simple validation command before upgrade operations.

Restore-DataGatewayClusterMember — Restore an existing gateway member to accelerate recovery and replacement scenarios.

Command improvements

Several existing commands are enhanced to improve flexibility and operational robustness:

Install-DataGateway

  • Added - TargetDirectory to support custom installation locations, enabling better alignment with enterprise server standards
Get-DataGatewayDatasourceStatus
  • Fixed failures when datasources are offline
  • Improved reliability for troubleshooting and monitoring scripts
Add-DataGatewayClusterDatasourceUser
  • Deprecated email-address-based user specification in favor of stronger identity-based approaches
Module quality improvements
  • Fixed module version display issues to ensure accurate reporting and easier environment validation across automation workflows.

What’s ahead

We will continue expanding gateway automation capabilities, improving command coverage, and enhancing admin experiences across UI, API, and scripting surfaces.

Learn more with the gateway PowerShell documentation and cmdlet reference on Microsoft Learn.

Labels:
0