Hello experts,
I'm fairly new to working with API. I've been trying this out without success and in need of assistance to see what went wrong and how could I fix it.
Powershell with Service Principle account is being used to perform this task, I believe all needed permission has been granted via Azure Active Directory.
Process
- Take Over Dataset - Success (Dataset was successfully taken over by the Service principle account)
- Disable Refresh Schedule - Fail (This is where the error shows up)
Script of the PowerShell
$Workspacename = xxx
$Datasetname = xxx
$ClientID = xxx
$ClientSecret = xxx
$TenantID = xxx
$applicationId = $ClientID # Need to pass the clientid from devops variable
$clientsec = $ClientSecret | ConvertTo-SecureString -AsPlainText -Force # Need to pass from devops secret variable
$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $applicationId, $clientsec
#Install-Module -Name MicrosoftPowerBIMgmt.Profile -Verbose -Scope CurrentUser -Force
#Install-Module -Name MicrosoftPowerBIMgmt.Workspaces -Verbose -Scope CurrentUser -Force
$Connect = Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -Environment Public -Tenant $TenantID
$workspace = Get-PowerBIWorkspace -Name $Workspacename
$DatasetResponse=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets" -Method Get | ConvertFrom-Json
$datasets = $DatasetResponse.value
foreach($dataset in $datasets){
if($dataset.name -eq $Datasetname){
$datasetid= $dataset.id;
break;
}
}
Invoke-PowerBIRestMethod -URL "groups/$($Workspace.id)/datasets/$($Dataset.id)/Default.TakeOver" -Method Post
$DisableScriptJson = @{
value= @{
enabled= "false"
}
} | ConvertTo-Json
Invoke-PowerBIRestMethod -URL "groups/$($Workspace.id)/datasets/$($Dataset.id)/refreshSchedule" -METHOD Patch -Body $DisableScriptJson | ConvertFrom-Json
Error
Invoke-PowerBIRestMethod : One or more errors occurred.
At line:42 char:2
+ Invoke-PowerBIRestMethod -URL "groups/$($Workspace.id)/datasets/$($D ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
Any help is appreciated, let me know if further information is needed
