Connect-PowerBIServiceAccount -Credential $Credential fails from Azure Automation Account

I'm trying to use MicrosoftPowerBIMgmt.Admin and MicrosoftPowerBIMgmt.Profile with Azure Automation Account to get Power BI audit logs and push them to a Storage Account with Az.Accounts nad Az.Storage.

I've created a user that has:

• Disabled password expiration
• Excluded from MFA
• RBAC contributor directly on the storage account
• Power BI Administrator in Azure AD

Problem is the Connect-PowerBIServiceAccount cmdlet.

From PowerShell ISE

When running $null = Connect-PowerBIServiceAccount -Credential $Credential from my machine, a black terminal pops up and disappears, and I get connected.

Modules

From Azure Automation Account

When running that from Automation Account with the same credential fetched from Automation Account Credentials, it causes the script to restart.

Modules

Q

How can we silently log in with a Azure AD user in a way that will work also from a Automation Account?

Start by reproducing Connect-PowerBIServiceAccount -Credential $Credential in Azure Automation and compare it with the PowerShell ISE behavior and the listed MicrosoftPowerBIMgmt and Az modules. Done means identifying a supported silent sign-in path that runs without restarting the Automation script and allows the audit-log workflow to continue.