Forum Discussion
On-premise DataGateway Powershell error: There was an error while trying to deserialize parameter
This is a known issue with the latest release of the gateway itself. Nothing is wrong with the cmdlet. If you install the July version of the gateway, the cmdlet commands work fine. I have an open ticket with the product team and they're investigating since they've been able to reproduce the error. TrackingID #2409190050002652.
Please guys!! Work hard to solve this!! Do your job well!!
The problem is resolved now. If you install the most recent DataGateway module it will work with the latest On-premises Data Gateway release. You can grab the latest DataGateway module from PowerShell Gallery | DataGateway 3000.244.23
However now I have another problem with the gateway where it's missing the Simba ODBC driver.
They resolved one and create other on my script Powershell , with the latest version my Connect-DataGatewayServiceAccount -ApplicationId $appId -ClientSecret (ConvertTo-SecureString -String $cSec -AsPlainText -Force) -Tenant $tId is not working. Gives me this error under and If I rollback to older version it works, but fail on the Add-DataGatewayCluster, such a mess they have!! QA needs to work more on this.
2024-10-01 15:29:49 - Failed to log into Power BI Service Account. Error: The 'Connect-DataGatewayServiceAccount' command was found in the module 'DataGateway.Profile', but the module could not be loaded due to the following error: [Could not load file or assembly 'System.Management.Automation, Version=7.4.4.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. The system cannot find the file specified.]
For more information, run 'Import-Module DataGateway.Profile'.PS C:\> Get-Module -ListAvailable Datagateway* Directory: C:\Program Files\PowerShell\Modules ModuleType Version PreRelease Name PSEdition ExportedCommands ---------- ------- ---------- ---- --------- ---------------- Binary 3000.244.… DataGateway Core {Add-DataGatewayCluster, Add-DataGatewa… Binary 3000.244.… DataGateway.Profile Core {Connect-DataGatewayServiceAccount, Dis… PS C:\> (Get-Module -ListAvailable Datagateway.Profile).ModuleBase C:\Program Files\PowerShell\Modules\DataGateway.Profile\3000.244.23 PS C:\> (Get-Module -ListAvailable Datagateway).ModuleBase C:\Program Files\PowerShell\Modules\DataGateway\3000.244.23I have only come across this issue when there is a gateway configured on the machine. Otherwise when there is no gateway configured the commands run just fine.
I was going to raise another ticket with them about this problem but it seems intermittent.