Forum Discussion

p24max's avatar
p24max
New Member
1 year ago
Solved

On-premise DataGateway Powershell error: There was an error while trying to deserialize parameter

Hi there,   I'm using IaC to automatically provision and recover a PowerBi On-Prem DataGateway with PowerShell (see command below). I'm using this approach since 8 month now and - so far - it worke...
Need Help
  • mzare's avatar
    mzare
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.23
mzare's avatar
mzare
Frequent Visitor
1 year ago

I 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.