Authenticate PowerBI in Azure Automate Powershell using cmdlets

[Anonymous]

Can anyone help me figure out how to authenticate my powerbi account in a powershell runbook so I can run PowerBI cmdlets?

I've tried many variations of this cmdlet:

Connect-PowerBIServiceAccount

with some built-in credentials. I'm driving myself crazy trying every variation I find on the web.

I honestly don't know where to start or why nothing is working.

Chris

[lbendlin]

Login-PowerBIServiceAccount

[Anonymous]

@lbendlin Thanks for the reply. This is an iteration of what I've tried and have gotten the same result. Could you explain a little more? 

[lbendlin]

That one works for me. Of course after that there's not much I can do since I am not a tenant admin.

[Anonymous]

I get the error: "The runbook job was attempted 3 times, but it failed each time". Is it different if I'm using a runbook?

[lbendlin]

Maybe.  Is your runbook running on Powershell Core 6 or better?

[Anonymous]

How do I figure that out? I'm doing all of this through Azure Automate.

[lbendlin]

$PSVersionTable.PSVersion

[Anonymous]

Major  Minor  Build  Revision
-----  -----  -----  --------
5      1      15063  726   

[lbendlin]

that's not enough. Can you upgrade to 6?

[Anonymous]

I just imported the update runbook and ran it. Not sure if there's anything else I need to do.

[lbendlin]

You need to update your Azure Automate instance to at least Powershell 6

[Anonymous]

Can you send documentation on this? I've been looking for a while and can't seem to find anything useful.

[lbendlin]

https://docs.microsoft.com/en-us/powershell/azure/install-az-ps?view=azps-4.2.0

[Anonymous · Accepted solution]

As a follow-up, I'm using the Powershell within Azure portal. I've been made aware that that powershell can't be updated and is currently on version 5. 

That's probably why I can't get anything to work on it.