(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 🙂
