topic Re: (PowerShell) Connect-PowerBIServiceAccount not working in Developer

(PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Fri, 19 Feb 2021 12:15:23 GMT

Hello folks,

Since yesterday I have been unable to log on to PBI service through PowerShell with the

Connect-PowerBIServiceAccount command. I have been working with PBI service management via PS scripts for some time, adding/deleting reports, refreshing datasets, managing refresh schedules an so on, and it has worked really well until now.

It is critical that the error is found quickly, since it is preventing me from doing my job and keeps the many PBI reports of our company hanging in an unmanaged state.

What could be the cause of this error? It turned up overnight and is not caused by any change in the scripts or developer environment (VS Code).

Here is the error mesage:

Request Id: 18389c28-151c-4286-aaf4-67606d172e00

Correlation Id: f79280b7-ad4f-4119-a7ad-5e6ef4b33032

Timestamp: 2021-02-19T11:53:23Z

Message: AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'ea0616ba-638b-4df5-95b9-636659ae5121'.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

Anonymous — Mon, 22 Feb 2021 06:36:40 GMT

Hi @h4tt3n,

I test the Connect-PowerBIServiceAccount with OAuth mode and it works well.

What authorization mode you work on? Did this issue still appear on your side? Any policy or rule change that applies to your device/environment? (they may block power bi requests) Please share more detailed information to help us clarify these.
How to Get Your Question Answered Quickly
Regards,

Xiaoxin Sheng

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Mon, 22 Feb 2021 06:48:32 GMT

Hi @Anonymous

The problem has disappeared again over the weekend. I assume it was due to overload on parts of the Microsoft servers or a small bug that was caught and fixed quickly.

Cheers, Mike

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Mon, 22 Feb 2021 06:49:20 GMT

Problem disappeared by itself after 3 days.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

Anonymous — Tue, 17 Aug 2021 11:51:27 GMT

Hi @Anonymous ,

I am experiencing the same exact problem today.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

alexgor87 — Mon, 23 Aug 2021 00:34:49 GMT

Hi @v-shex-msft, I have this problem for a week already and it doesn't go away.
I've also checked App Registrations and there is no such app with the ID 'ea0616ba-638b-4df5-95b9-636659ae5121'. Any thoughts? Thanks

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Mon, 23 Aug 2021 06:05:25 GMT

OP here, now we are experiencing the same problem again, and is has persisted for several days.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Tue, 24 Aug 2021 10:05:32 GMT

OP here. The problem has returned again, and has persisted for about a week. No changes has been made on our side to any PS scripts. We get the exact same error message. What is the issue, and can we do anything about it?

Re: (PowerShell) Connect-PowerBIServiceAccount not working

Anonymous — Thu, 26 Aug 2021 06:05:15 GMT

Hi @alexgor87,

If you do not change the setting on these function usage but this issue appears frequently. It means the issues may be related to some backend/remote processing of these function usages.
In my opinion, I'd like to suggest contact to the author of the packages to report this.

Regards,

Xiaoxin Sheng

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Thu, 26 Aug 2021 06:25:20 GMT

Exactly my thought. We use Microsofts official PowerBi management package, so I think the best thing to do is open a ticket with their support.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

alexgor87 — Thu, 26 Aug 2021 07:54:54 GMT

I was just about to raise the ticket, and I checked the version of the MicrosoftPowerBIMgmt package. Mine was 1.0.896, while the latest is 1.2.1026:
https://www.powershellgallery.com/packages/MicrosoftPowerBIMgmt/1.2.1026

So I updated the module and all dependent modules:
MicrosoftPowerBIMgmt.Admin (>= 1.2.1026)
MicrosoftPowerBIMgmt.Capacities (>= 1.2.1026)
MicrosoftPowerBIMgmt.Data (>= 1.2.1026)
MicrosoftPowerBIMgmt.Profile (>= 1.2.1026)
MicrosoftPowerBIMgmt.Reports (>= 1.2.1026)
MicrosoftPowerBIMgmt.Workspaces (>= 1.2.1026)

and the problem has gone! Hope this will work for you too!

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Thu, 26 Aug 2021 08:26:56 GMT

Thank you for the feedback. I have tried this solution, but unfortunately it did not solve the problem. May I ask what dev tools you are using? I am using VS code with powershell 5.1 for development.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

Anonymous — Thu, 26 Aug 2021 08:36:27 GMT

I uninstalled the powershell module and reinstalled it again to update to the latest version.

I now receive a different error:

Login-PowerBI -Credential $credential
Login-PowerBI : One or more errors occurred.
At line:1 char:5
+ Login-PowerBI -Credential $credential
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...IServiceAccount:ConnectPowerBIServiceAccount) [Connect-PowerBIServiceAccount], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.ConnectPowerBIServiceAccount

WARNING: (False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.19042.0 [08/26/2021 08:30:16 - a8595795-2a3c-4957-a9c1-289ad9698d27] Request retry failed.
WARNING: (False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.19042.0 [08/26/2021 08:30:16 - a8595795-2a3c-4957-a9c1-289ad9698d27] Exception type: Microsoft.Identity.Client.MsalUiRequ
iredException
, ErrorCode: invalid_grant
HTTP StatusCode 400
CorrelationId a8595795-2a3c-4957-a9c1-289ad9698d27

WARNING: (False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.19042.0 [08/26/2021 08:30:16 - a8595795-2a3c-4957-a9c1-289ad9698d27] Exception type: Microsoft.Identity.Client.MsalUiRequ
iredException
, ErrorCode: invalid_grant
HTTP StatusCode 400
CorrelationId a8595795-2a3c-4957-a9c1-289ad9698d27

at Microsoft.Identity.Client.OAuth2.OAuth2Client.ThrowServerException(HttpResponse response, RequestContext requestContext)
at Microsoft.Identity.Client.OAuth2.OAuth2Client.CreateResponse[T](HttpResponse response, RequestContext requestContext)
at Microsoft.Identity.Client.OAuth2.OAuth2Client.<ExecuteRequestAsync>d__11`1.MoveNext()

Re: (PowerShell) Connect-PowerBIServiceAccount not working

alexgor87 — Fri, 27 Aug 2021 00:17:30 GMT

I was running the commands from the standard Windows PowerShell terminal (5.1) as administrator. I also have VS Code, but I don't use very complex scripts so there's nothing much to develop at the moment.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Fri, 27 Aug 2021 10:57:38 GMT

This is interesting: The script runs fine in the PowerShell ISE editor, but it won't run in VS code. IF you are having problems, try updating the MicrosoftPowerBIMgmt module with the command:

Install-Module MicrosoftPowerBIMgmt -force -AllowClobber

and then run the script in either PS command line tool or ISE. This has worked for me.

However, since VS code is a superior toll over cmd or ISE, and sinc it is a Microsoft product, I am holding my support ticket open.

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Fri, 27 Aug 2021 11:07:25 GMT

OP here, problem is partially solved. The script runs fine in the PowerShell ISE editor, but it won't run in VS code. If you are having problems, try updating the MicrosoftPowerBIMgmt module with the command:

Re: (PowerShell) Connect-PowerBIServiceAccount not working

h4tt3n — Fri, 10 Sep 2021 12:12:14 GMT

Problem found and solved!

It turned out that an update to the PowerShell extension for VS Code set this value "powershell.useX86Host": true. In other words, it started running 32 bit as default. Manually changing it back to x64 like shown in the screenshots belov solved the problem:

Cheers, Mike

Re: (PowerShell) Connect-PowerBIServiceAccount not working

carloscantu — Sat, 13 Nov 2021 16:47:18 GMT

This fixed the issue for me, thank you for sharing!

Re: (PowerShell) Connect-PowerBIServiceAccount not working

agneum — Fri, 22 Jul 2022 11:56:23 GMT

I was using Service Principal method to sign in and had the same error. I was noticed it was working fine in x86 version of PowerShell ISE however.

The problem
Connect-PowerBIServiceAccount -ServicePrincipal -CertificateThumbprint xxxx -ApplicationId xxxx

..Kept throwing errors such as :

Login-PowerBIServiceAccount : One or more errors occurred.
At line:1 char:1
+ Login-PowerBIServiceAccount
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...IServiceAccount:ConnectPowerBIServiceAccount) [Connect-PowerBIServiceAccount], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.ConnectPowerBIServiceAccount

My solution was this:

1) Close all open powershell sessions. Go to C:\Program Files\WindowsPowerShell\Modules and delete all MicrosoftPowerBIMgmt modules (folders) manually

2) Open PowerShell ISE as admin , and run

 [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
  Unregister-PSRepository -Name PSGallery
  Register-PSRepository -Default

3) Make sure this command works and finds shows version of 1.2.1077 (or above)

 Find-Module MicrosoftPowerBIMgmt

3) Install the module again

 Install-Module MicrosoftPowerBIMgmt -force -AllowClobber

The service account (app registration) needed access to the Power BI API, and I also had to enable "Allow service principals to use Power BI APIs" under tenant settings. (I used security group at first, but removed it, not sure if it's related to the issue)