topic Re: PowerShell Connection help in Developer

PowerShell Connection help

ChopperDave — Fri, 11 Aug 2023 20:13:54 GMT

Hi,

I'm trying to get a service principal set up so I can connect to PowerBI with PowerShell. I want to do it in the background so the user won't have any interaction with the scripts.

I've been following along with a video a found https://youtu.be/WaKvZgjTWmo?t=2937 but am running into a permissions issue.

Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized'

I've set up the App Registration in Azure, set up a secret, and added the App as an admin on the PowerBI workspace. Also enabled developer settings in PowerBI and added a AD group that I set up to use PowerBI APIs. I even added the App as a member of the AD group despite it not being strictly instructed.

Maybe that's what I'm missing. I don't see any instructions on how to connect the AD group to the App.

I'd be happy to provide more information if needed.

Re: PowerShell Connection help

ChopperDave — Fri, 11 Aug 2023 20:33:52 GMT

It's defiantly an issue with the "Allow service principals to use Power BI APIs" setting. I enabled it for "The entire organization" and it started working.

Not sure how to get the App in the group that I have set up.

Re: PowerShell Connection help

ChopperDave — Fri, 11 Aug 2023 20:45:02 GMT

Turns out I'm blind and didn't see that you could add the Service Principal in the AD group. Spent way too long on that.

I'll keep my shame up here incase anyone else has the same problem.