Using Power BI's APIs in powershell scripts - 400 status error

Sapphire — Fri, 16 Apr 2021 18:46:13 GMT

Hello, I am new to powershell and was working on using Power BI REST APIs. I have no problems with the ones using read permissions, but when it comes to the ones to write (POST), i am getting the following error:

Exception : System.Net.Http.HttpRequestException: Response status code does not indicate success: 400 (Bad Request).
at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
at Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod.<InvokeRestMethod>d__35.MoveNext() (the error is on the image on top!)

In this case i was using the following for the "update parameter in group" REST API:

Invoke-PowerBIRestMethod -Url $url -Method POST -Body (ConvertTo-Json #body_request)

$body_request = @'
{
"updateDetails":
{
"name": "ServerName",
"newValue": "qa-clean"
}

}
'@

I may be wrong, but I read documentation before which told that administrators can use the Power BI APIs without needing to register an app in azure. Is this fact true?

Thank you for reading:)

Re: Using Power BI's APIs in powershell scripts - 400 status error

lbendlin — Sat, 17 Apr 2021 19:17:09 GMT

Try running the same API call in the sandbox.

Datasets - Update Parameters In Group (Power BI Power BI REST APIs) | Microsoft Docs

topic Using Power BI's APIs in powershell scripts - 400 status error in Developer

Using Power BI's APIs in powershell scripts - 400 status error

Re: Using Power BI's APIs in powershell scripts - 400 status error