Power bi ошибка 500

Thanks Michael_Shao,

I think Power BI used to ask me if I wanted to replace the dataset before loading. But I don’t get this prompt anymore Error 500 comes up.

The Fiddler Trace shows the following.

And the Power BI Trace shows the following.

{«dt»:»e»,»ct»:1472623943,»u»:»ee15a6e3-f2f0-4151-8ab1-cdf70c42d9ff»,»su»:»a76a725a-d92a-41c2-ab66-e539c239a37f»,»n»:»PBI.Win.UploadReportToPowerBIService»,»attrs»:{«backendUrl»:»https://api.powerbi.com/»,»activityId»:»79bc70ab-beb9-4593-a5cf-eea4964dd4a2″,»requestId»:»7c0485f6-… — 100ms»,»client»:»WinDesktop»,»build»:»2.38.4491.282 (PBIDesktop)»,»uiCulture»:»en-US»,»clientCulture»:»en-AU»,»isInternal»:»False»}}
{«dt»:»e»,»ct»:1472623947,»u»:»1e1ed5c0-f74f-4578-b7f1-78da446620ee»,»su»:»a76a725a-d92a-41c2-ab66-e539c239a37f»,»n»:»PBI.PQ.PublishingFailedInternal»,»attrs»:{«backendUrl»:»https://api.powerbi.com/»,»activityId»:»79bc70ab-beb9-4593-a5cf-eea4964dd4a2″,»requestId»:»7c0485f6-… (PBIDesktop)»,»uiCulture»:»en-US»,»clientCulture»:»en-AU»,»isInternal»:»False»}}

Sorry that I can’t load this in OneDrive. Our organisation actually doesn’t have OneDrive set up.

Update: I repaired Power BI. No difference in outcome. Power BI doesn’t ask if I want to replace the dataset, instead jumping straight to Error 500.

When posting to the Power BI api uri: https://api.powerbi.com/v1.0/myorg/groups in PowerShell version 5.1.17134.228, I got the error:

The remote server returned an error: (500) Internal Server Error.

I invoked the Power BI rest api with the PowerShell script you can find below.

The error was fixed, when I added -ContentType ‘application/json’ parameter to the InvokeRestMethod

PowerShell script

$clientId = “my-client-id”

$PowerBIUserName = “MyUserName”

$PowerBIUserPassword = “MyUserPassword”

$creds = New-Object “Microsoft.IdentityModel.Clients.ActiveDirectory.UserCredential” -ArgumentList $PowerBIUserName,$PowerBIUserPassword

$resourceAppIdURI = “https://analysis.windows.net/powerbi/api”

$authority = “https://login.microsoftonline.com/common/oauth2/authorize”;

$authContext = New-Object “Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext” -ArgumentList $authority

# Acquire token

$authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $creds)

# Create a new group

$auth_header = @{

‘Authorization’=$token.CreateAuthorizationHeader()

}

$uri = “https://api.powerbi.com/v1.0/myorg/groups”

$body = “{`”name`”:`”myNewGroup`”}”

$response = Invoke-RestMethod -Uri $uri -Headers $auth_header -Method POST -Body $body -ContentType ‘application/json’

$target_group_id = $response.id

Load 7 more related questions

Show fewer related questions

Load 7 more related questions

Show fewer related questions