topic Call any Power BI REST API with PowerShell issue in Developer

Call any Power BI REST API with PowerShell issue

kanth999 — Thu, 21 Apr 2022 07:45:59 GMT

@ links to members

I am trying to refresh the PoweBI dataset from PowerBI rest API using Powershell getting below error can you please help me how to fix the issue

using command

Invoke-PowerBIRestMethod -Url "datasets/19b9e00-e8f2-4f81-baae-e2ee907af256/refreshes" -Method Post

getting error

Invoke-PowerBIRestMethod: One or more errors occurred. (Response status code does not indicate success: 404 (Not Found).)

Note: i am running this command on Mac

Re: Call any Power BI REST API with PowerShell issue

pvuppala — Thu, 21 Apr 2022 18:04:45 GMT

You're missing some syntax. Here's what works for me.

$body = "{`n `"notifyOption`": `"MailOnFailure`",`n}"
$headers = Get-PowerBIAccessToken
$headers.Add("Content-Type", "application/json")

Try
{

$data_refresh= Invoke-RestMethod -Uri 'https://api.powerbi.com/v1.0/myorg/groups/GROUPID/datasets/DATASETID/refreshes' -Method 'POST' -Headers $headers -Body $body
Write-Host "Refresh Completed! " -ForegroundColor "Green";

}
Catch
{
Write-Host "Failed to Refresh Data! " -ForegroundColor "Red";
Write-Host "StatusCode:" $_.Exception.Response.StatusCode.value__
Write-Host "StatusDescription:" $_.Exception.Response.StatusDescription
}

Re: Call any Power BI REST API with PowerShell issue

kanth999 — Fri, 22 Apr 2022 00:32:05 GMT

Hi,

thanks for your reply ,

I am using MAC OS and installed the Powershell Install-Module -Name MicrosoftPowerBIMgmt command when i try lo login powerbi getting this issue and also when i execute the above commands not able to run getting issue of below

any idea how we can use

Microsoft Power BI Cmdlets for Mac PowerShell and PowerShell Core