Problems using Invoke-PowerBiRestMethod in PowerShell

(I'm no PowerShell expert)

I'm trying to script PowerBI dataset refreshes using a PowerShell script and the Invoke-PowerBIRestMethod.

It all works fine for a single hardcoded dataset, as below:

$body = "{'notifyOption':'MailOnCompletion'}"
$result = Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/datasets/xxxxxxxxxxxxxxxxxxxxxxxxxx/refreshes" -Method POST -Body $body

However, I'd like to store all my dataset IDs in a txt file, then pass these in as a variable and get the script to loop through each. This is where I'm hitting (unhelpful) errors.

My script is as below:

Login-PowerBI

$body = "{'notifyOption':'MailOnCompletion'}"
$Data=Import-Csv -Path "\\abc\Desktop\PBI_Dashboards_Refresh_List.txt" -Delimiter ","

foreach ($dat in $Data)

{
$result = Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/datasets/$dat.WorkspaceID/refreshes" -Method POST -Body $body

}
Resolve-PowerBIError -Last

The error I'm getting is:

Message : Response status code does not indicate success: 404 (Not Found).
StackTrace : at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
at Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod.<InvokeRestMethod>d__35.MoveNext()
Exception : System.Net.Http.HttpRequestException
InvocationInfo : {Invoke-PowerBIRestMethod}
Line : $result = Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/datasets/$dat.WorkspaceID/refreshes" -Method POST -Body $body

Position : At line:7 char:15
+ ... $result = Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HistoryId : 25

Any help appreciated 🙂