Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
(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 🙂
Solved! Go to Solution.
Hi @g_m_j ,
According to your statement, I think 404 error should be an authentication error in Power BI. Please make sure your account has access to Power BI or have access to pass the refresh API to Power BI.
About using Powershell to refresh dataset, I think this blog could help you better to use it:
Using-the-power-bi-api-with-powershell-scripts-refreshing-your-dataset
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @g_m_j ,
According to your statement, I think 404 error should be an authentication error in Power BI. Please make sure your account has access to Power BI or have access to pass the refresh API to Power BI.
About using Powershell to refresh dataset, I think this blog could help you better to use it:
Using-the-power-bi-api-with-powershell-scripts-refreshing-your-dataset
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.