Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Authenticate PowerBI in Azure Automate Powershell using cmdlets

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
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

14 REPLIES 14
lbendlin
Super User
Super User

Login-PowerBIServiceAccount

Anonymous
Not applicable

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

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

Anonymous
Not applicable

 

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?

 
 

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

Anonymous
Not applicable

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

$PSVersionTable.PSVersion

Anonymous
Not applicable

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

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

Anonymous
Not applicable

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

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

Anonymous
Not applicable

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

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.