topic Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets in Developer

Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Thu, 18 Jun 2020 03:18:37 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 02:04:35 GMT

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 02:14:35 GMT

@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?

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 02:35:02 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 02:45:00 GMT

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?

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 02:47:20 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 02:50:50 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 02:53:46 GMT

$PSVersionTable.PSVersion

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 02:57:03 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 03:09:19 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 03:34:07 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Fri, 19 Jun 2020 16:47:34 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Fri, 19 Jun 2020 17:55:31 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

lbendlin — Sat, 20 Jun 2020 01:04:57 GMT

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

Re: Authenticate PowerBI in Azure Automate Powershell using cmdlets

Anonymous — Wed, 24 Jun 2020 15:10:53 GMT

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.