I am using PowerShell to pull Dataset information and we are now using Dataflows and am unable to pull the schedules that are setup on the Dataflows. I have tried using the same method that works for Datasets but the Get method is erroring when I try to use it. I have looked online and cannot find anything on pulling Dataflow schedules.
The code I am using is which works if I use /datasets/ instead of /Dataflows/
$Workspaces = Get-PowerBIWorkspace -Scope Organization -All
foreach($workspace in $Workspaces)
{
if( $workspace.Type -in ('Workspace' ) -and $workspace.State -eq 'Active' )
{
$workspace.Name
$DataSets = Get-PowerBIDataflow -WorkspaceId $workspace.Id #| where {$_.isRefreshable -eq $true }
foreach($dataset in $DataSets)
{
$dataset.Name
if ($dataset.Name -notin ( 'Report Usage Metrics Model','Dashboard Usage Metrics Model') ) {
$URI = "groups/" + $workspace.id + "/dataflows/" + $dataset.id + "/refreshSchedule"
$DataSourceResults = Invoke-PowerBIRestMethod -Url $URI -Method Get | ConvertFrom-Json #-ErrorAction SilentlyContinue
}
}
}
}
It is the Get that causes this Error:
Invoke-PowerBIRestMethod : One or more errors occurred.
At line:1 char:1
+ Invoke-PowerBIRestMethod -Url "groups/a609a8eb-7507-....
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
