Data Gateway PowerShell module issue with `Add-DataGatewayClusterMember` command `-RegionKey` param
Hi all, I recently encountered an issue with the latest version of DataGateway PowerShell module (latest version of PS7 and DataGateway service): https://www.powershellgallery.com/packages/DataGateway/3000.196.145 PS C:\> (Get-Module DataGateway).version Major Minor Build Revision ----- ----- ----- -------- 3000 196 145 -1 PS C:\> $PSVersionTable Name Value ---- ----- PSVersion 7.4.3 PS C:\> (Get-Item "C:\Program Files\On-premises data gateway\Microsoft.PowerBI.EnterpriseGateway.exe").VersionInfo.FileVersion 3000.226.5 `Add-DataGatewayClusterMember` command doesn't seem to respect `-RegionKey` parameter, whenever it's passed to the command, it cannot find the GatewayClusterId in the specified region. # Info: Gateway cluster xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx is created in uksouth region PS C:\> Add-DataGatewayClusterMember -GatewayClusterId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -GatewayName datagatewaypoc-2 -RecoveryKey $secureRecoveryKey -OverwriteExistingGateway -RegionKey uksouth Add-DataGatewayClusterMember: Gateway cluster xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx was not found When the cluster is deployed in a default PowerBI tenant region and when `-RegionKey` parameter is not passed then it works as it should. # Info: Gateway cluster xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx is created in PowerBI default tenant (northeurope in that case) PS C:\> Add-DataGatewayClusterMember -GatewayClusterId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -GatewayName datagatewaypoc-2 -RecoveryKey $secureRecoveryKey -OverwriteExistingGateway GatewayId GatewayObjectId GatewayName GatewayType --------- --------------- ----------- ----------- xxxxxx xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx datagatewaypoc-2 Resource Also, `Add-DataGatewayClusterMember` is not documented at all, the only mention is in the blog post regarding release notes from 2023.10: https://learn.microsoft.com/en-us/powershell/module/datagateway/remove-datagatewayclustermember?view=datagateway-ps https://powerbi.microsoft.com/en-in/blog/on-premises-data-gateway-october-2023-release/ dazhang
Can't refresh reports. On-Premise Gateway / DNS Problem?
Hello, I have a problem with data refresh through an On-Premise Gateway. Both planned and manual refresh are causing issues. All reports are affected. It usually takes too long to refresh (over 10 min.) and then this error code is shown. There were times when I could refresh my reports manually today, but the issue kept showing later again. I tested reports with data from different SQ servers. Then I created a new gateway on my pc and turned off the gateway we have in our virtual power bi server. The issue remained. I started to track the data traffic and apparently the gateway is sending data to these Microsoft domains: g0-prod-fra21-001-sb.servicebus.windows.net g1 g2 ... g15-prod-fra21-001-sb.servicebus.windows.net Some of these domains return a local IP address, tested with different public DNS. Currently, g8 is returning 10.218.0.23, g9 returns 10.218.0.24, g15 returns 10.218.0.30. Others seem to have a public IP, like g0 with 51.116.232.39 for example, and the traffic goes through. I'm assuming this might be the reason sometimes the refresh works and sometimes it doesn't. Is someone else having a similar problem?
