topic Powershell script error - Unauthorized in Developer

Powershell script error - Unauthorized

Anonymous — Wed, 29 Dec 2021 13:33:54 GMT

Hi,

I have Power BI administrator role in my organization. I want to view how many workspaces have been created, therefore I was running the simple below Powershell script :

Login-PowerBIServiceAccount

$groups = Get-PowerBIGroup -Scope Organization -All

$groups

While running the script I am getting error below error:

Am I missing any other admin rights to extract the information of Power BI Service ?

Re: Powershell script error - Unauthorized

Watsky — Thu, 30 Dec 2021 02:36:36 GMT

Hey @Anonymous ,

One (1) thought, do you work in the regular commerical environment? If your tenant is not in the regular commerical Power BI environment then you would need to set your environment. For instance, I work in GCC so I have to set my environment as such:

Re: Powershell script error - Unauthorized

Anonymous — Thu, 30 Dec 2021 13:22:53 GMT

Hi @Watsky ,

Thank you for the reply. Can you explain what is "regular commercial environment" ? And how do I know what are options we have for -Environment similar to "USGov" ?

Regards,

ankbaner

Re: Powershell script error - Unauthorized

Watsky — Thu, 30 Dec 2021 13:56:10 GMT

When you log into the Power BI service what is the url that you're connecting to? Is it app.powerbi.com or is it something else? These are the options as show via Power Shell:

Re: Powershell script error - Unauthorized

Anonymous — Sun, 02 Jan 2022 09:36:39 GMT

Hi @Watsky ,

Yes I am connecting to app.powerbi.com from Finland. I tried 3 options from "-Environment" i.e. Custom, Germany and Public but neither of the options worked.

Re: Powershell script error - Unauthorized

Anonymous — Tue, 04 Jan 2022 01:57:58 GMT

Hi @Anonymous,

I think Watsky means the general organization and gov/national organization. The gov/national should be different from the common organization.

In addition, the rest API is required to enable the permissions. Have you checked the account include the corresponding permissions and scopes that API required?

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Docs

Microsoft identity platform scopes, permissions, & consent | Microsoft Docs

Regards,
Xiaoxin Sheng