topic Re: Power BI PowerShell - A task was canceled.,Microsoft.PowerBI.Commands.Reports.GetPowerBIReport in Developer

Power BI PowerShell - A task was canceled.,Microsoft.PowerBI.Commands.Reports.GetPowerBIReport

Dhruvin27 — Thu, 17 Mar 2022 04:34:41 GMT

I have 1500+ Workspaces in my Power BI Tenant. When I loop through the Workspaces and try to Get Reports using the following code snippet, it is working for few workspaces. Around (30 Workspace).

$report = Get-PowerBIReport -Scope Organization -WorkspaceId $WS.Id

After that it started propmpting the following error!

+ CategoryInfo : WriteError: (Microsoft.Power...etPowerBIReport:GetPowerBIRep ort) [Get-PowerBIReport], TaskCanceledException + FullyQualifiedErrorId : A task was canceled.,Microsoft.PowerBI.Commands.Reports.GetP owerBIReport

Then, any script execution is failing. Is there any Limit to call PowerShell command ? Is there any Timeout Problem with Power BI PowerShell? Any solution for this problem?

Re: Power BI PowerShell - A task was canceled.,Microsoft.PowerBI.Commands.Reports.GetPowerBIReport

lbendlin — Thu, 17 Mar 2022 23:35:48 GMT

Use Invoke-RestMethod with this API call

Admin - Groups GetGroupsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

It supports filtering and pagination, and generally has better performance.

Re: Power BI PowerShell - A task was canceled.,Microsoft.PowerBI.Commands.Reports.GetPowerBIReport

AndreaQ — Mon, 05 Sep 2022 16:27:18 GMT

You can integrate request with this script. Timeout seconds are in $timesleep. just looping it ...

i use for

Add-PowerBIWorkspaceUser

don't forget if statement

$apiTraceback = Resolve-PowerBIError -Last 
$text = $apiTraceback.Response
[regex]$usernameReg = "(\d\d\d\d)"
$timesleep= $usernameReg.Match($text).Value
Start-Sleep -s $timesleep