Forum Discussion

kanth999's avatar
kanth999
Helper I
4 years ago

Call any Power BI REST API with PowerShell issue

@ 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).)

 


  1. Note: i am running this command on Mac 
Need Help

2 Replies

Replies have been turned off for this discussion
  • pvuppala's avatar
    pvuppala
    Helper V
    4 years ago

    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
    }

    • kanth999's avatar
      kanth999
      Helper I
      4 years ago

      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