Forum Discussion

mzare's avatar
mzare
Frequent Visitor
1 year ago
Solved

Issue with gateway cmdlet Connect-DataGatewayServiceAccount

I use the DataGateway cmdlet to manage my Data Gateway clusters. I use Azure Key Vault to store service principal secrets and use Az module to read these secrets. Like below:       Install-Modu...
Need Help
  • mzare's avatar
    mzare
    1 year ago

    As final update, Microsoft has confirmed that the issue exists and the DataGateway cmdlet is not compatible with Az PowerShell cmdlet. The problem that I have described above does not get resolved by disconnecting Az Account using `Disconnect-AzAccount` or even removing the Az module using `Remove-Module -Name Az`.

    Microsoft has responded that they are going to deploy a fix but it'll be after a month. Therefore I'm closing this thread now and give an update in another forum when there is a fix.

Expiscornovus's avatar
Expiscornovus
Most Valuable Professional
1 year ago

Hi mzare,

 

Can you run the below after the Install-Module -Name DataGateway line and share the outputs?

 

Just want to double check if you are using PS 7 (and which specific version). And if you are running versions of the module side by side.

 

In other words:

Install-Module -Name DataGateway -Confirm:$False -Force
$PSVersionTable
Get-Module DataGateway -ListAvailable | Select ModuleType,Version,Name

 

  • mzare's avatar
    mzare
    Frequent Visitor
    1 year ago

     

    To ellaborate the issue further I've run the two scenarios below. The first screenshot is where I do not use Az module to get the service principal secrets.

    This scenario is where connect to Azure account using `Connect-AzAccount` first and without reading the key vault secrets the `Connect-DataGatewayServiceAccount` command fails to connect to Power BI service.

     

    • Expiscornovus's avatar
      Expiscornovus
      Most Valuable Professional
      1 year ago

      Hi mzare,

       

      Can you add the -Verbose parameter at the end of your Connect-DataGatewayServiceAccount line and see if that gives you more information?

       

       

      Btw, what is the Az module version you are using? That would be useful to know to reproduce your issue.

      • mzare's avatar
        mzare
        Frequent Visitor
        1 year ago

        Same error message with verbose option added. I'm using latest versions of Az and DataGateway as my solution runs on a vmss that gets redeployed every day with the latest version of the cmdlets.

        I've also received this from microsoft support:

        According to our documentation, the Connect-DataGatewayServiceAccount cmdlet appears to be incompatible with the Az module, but we are currently investigating internally to find any possibility.