How can I run Login-DataGatewayServiceAccount programatically using powershell ?

[mrflinstone]

Hi all.

I have got a script that queries data gateways for power BI, during testing I am able to login using Get-DataGatewayClusterDatasourceStatus however using our automation system requires the login to be non-interactive but rather programatically I cannot get it to work. I will require an alternative way to call Get-DataGatewayClusterDatasourceStatus passing the application ID and the application secret.

I have tried  Connect-DataGatewayServiceAccount to no avail

[Anonymous]

Hi @mrflinstone ,

Regarding your question, if you have problems writing PowerShell code, check if the sample code in the following article can give you some inspiration.

PowerBI-cmdlets/notebooks/PowerBI_Gateway_Overview.ipynb at master · itsnotaboutthecell/PowerBI-cmdl...

Best Regards,
Wenbin Zhou

[mrflinstone]

Currently trying to use a service principal in order to check power BI connection status

Connect-DataGatewayServiceAccount -ApplicationId $xx -ClientSecret $xx -Tenant "xx"
$scopeLevel = "Organization"

Get-DataGatewayCluster -Scope $scopeLevel

I am getting the error below

`Response status code does not indicate success: 401 (Unauthorized) Request Id:`

Does suggest a permission issue, however the service principal is a global admin in Azure, not sure what other permission may be required.

Is there any other way to use a service principal with

Login-DataGatewayServiceAccount