Login-PowerBI | Out-Null $workspaceId = '' $datasetId = Get-PowerBIDataset -WorkspaceId $workspaceId ` | Where{$_.Name -match "AdventureWorks"} ` | Select-Object -ExpandProperty Id -First 1 ` | ForEach-Object {$_.Guid} Invoke-PowerBIRestMethod -Url "groups/$workspaceId/datasets/$datasetId" ` -Method Patch -Body '{ "queryScaleOutSettings": { "maxReadOnlyReplicas": 0 }}' $response = Invoke-PowerBIRestMethod -Url "groups/$workspaceId/datasets/$datasetId" -Method Get | ConvertFrom-Json $response.queryScaleOutSettings | Format-List Invoke-PowerBIRestMethod -Url "groups/$workspaceId/datasets/$datasetId/queryScaleOut/syncStatus" -Method Get | ConvertFrom-Json | Format-List