topic Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app. in Service

Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

saivina2920 — Mon, 21 Nov 2022 13:10:30 GMT

I am getting error in the below line while connecting Power BI with embed app.

I have give all id's in JSON settings like below.

"AzureAd": {
"AuthenticationMode": "ServicePrincipal",
//"AuthorityUrl": "https://login.microsoftonline.com/organizations/",
"AuthorityUrl": "https://login.microsoftonline.com/que8ad7-adsd-w22sf-23iuhsasd",
"ClientId": "fdsguy-erhdj-rtyuiw-32987ud-fdwiu8ds7s",
"TenantId": "8fdf987ad87-dsafi-ytrt5-niuwoiuafm09er9",
"ScopeBase": [ "https://analysis.windows.net/powerbi/api/.default" ],
"PbiUsername": "comp1@tek.com",
"PbiPassword": "************",
"ClientSecret": "fdsgshfgajdad-dafdbvnvfoiepi-3edfsfdshj"
},
"PowerBI": {
"WorkspaceId": "4398dsewwsdfkg-fdijo-hoigu-kjfdj-irkfjfjdsa0w987e",
"ReportId": "fvxcn-cvkbvj-vcxbivc-vcxbj-er9rekjxlj",
"DataSetId": "hfakjfdadaf-adsfljjreuu8-fdld87fsf-fsghfkfs"

But, still i am getting below error.

Error Details:
Operation returned an invalid status code 'Unauthorized'

at Microsoft.PowerBI.Api.ReportsOperations.GetReportInGroupWithHttpMessagesAsync(Guid groupId, Guid reportId, Dictionary`2 customHeaders, CancellationToken cancellationToken)
at Microsoft.PowerBI.Api.ReportsOperationsExtensions.GetReportInGroupAsync(IReportsOperations operations, Guid groupId, Guid reportId, CancellationToken cancellationToken)
at Microsoft.PowerBI.Api.ReportsOperationsExtensions.GetReportInGroup(IReportsOperations operations, Guid groupId, Guid reportId)
at AppOwnsData.Services.PbiEmbedService.GetEmbedParams(Guid workspaceId, Guid reportId, Guid additionalDatasetId) in C:\Users\PowerBI-Developer-Samples-master\.NET Core\Embed for your customers\AppOwnsData\Services\PbiEmbedService.cs:line 46
at AppOwnsData.Controllers.EmbedInfoController.GetEmbedInfo() in C:\Users\PowerBI-Developer-Samples-master\.NET Core\Embed for your customers\AppOwnsData\Controllers\EmbedInfoController.cs:line 45

below is my code

public PowerBIClient GetPowerBIClient()
{
var tokenCredentials = new TokenCredentials(aadService.GetAccessToken(), "Bearer");
return new PowerBIClient(new Uri(powerBiApiUrl ), tokenCredentials);
}

Error line

*******************

PowerBIClient pbiClient = this.GetPowerBIClient();

// Get report info
var pbiReport = pbiClient.Reports.GetReportInGroup(workspaceId, reportId); ==> Error Line

What is the error and how we could solve this....?

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

saivina2920 — Tue, 22 Nov 2022 05:00:16 GMT

Anyone can update relate this issue pls..

This is very very urgent.

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

Anonymous — Tue, 22 Nov 2022 09:53:35 GMT

Hi saivina2920 ,

Could it be permission issue?

The account must be the admin of the related workspaces when you need to embeded report in the application.

Best Regards,

Jay

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

saivina2920 — Tue, 22 Nov 2022 10:23:30 GMT

Yes. It's great.

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

MRIZ — Mon, 11 Sep 2023 10:51:11 GMT

Hi you got any solution. I am stuck in same issue!

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

Anonymous — Wed, 27 Dec 2023 08:04:24 GMT

same issue too, do you have any solution

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

MRIZ — Wed, 27 Dec 2023 08:18:41 GMT

Hi, yes this issue was resolved for me. I did different things i am forgetting it, I guess I was forgetting to give admin access to my Service Pricncipal on my WorkSpace is Worspace Access option.

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

Anonymous — Wed, 27 Dec 2023 08:20:57 GMT

thanks. But i have done this

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

MRIZ — Wed, 27 Dec 2023 08:36:33 GMT

OneDriveAppOwnsData.sln

this is running project for your reference. May be it can help you!!

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

Anonymous — Wed, 27 Dec 2023 08:41:13 GMT

thanks, this is only the sln file, maybe you miss some others. And I want to know if you use the service principle to add or update data to powerBI, I can access to getworkspace, but fialed when try to upload new report, meet the 'unauthorized', I think maybe it is read-only?

Re: Operation returned an invalid status code 'Unauthorized' while connecting Power BI embed app.

MRIZ — Wed, 27 Dec 2023 08:49:20 GMT

Sorry for inconvinience, PFB updated link
Check if this runs for you or not after replacing all the values in json
Embed for your customers.rar