Hello, i hope you´re doing well.
I´m having this issue every time i try to modify credential of the Dataset.
Invoke-PowerBIRestMethod : One or more errors occurred.
At C:\Users\ZN661HL\source\repos\ImportantStaff\CICD\ModifyDatasetCredential.ps1:61 char:16
+ ... $response= Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.va ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
This is the Code i´m using:
$datasetname = "DummyPBIDataset"
$workspacename = "CIT Datawarehouse - QA"
## user credentials
$username = "xxxxxxxxxxx"
$password = "xxxxxxxxx"
$client_secret_temp = "?xxxxxxxxx" | ConvertTo-SecureString -AsPlainText -Force
$client_id_temp = "xxxxxxxxxxxx"
$tenant_id_temp = "xxxxxxxxxxxxxxxxxx"
#$clientsec = "?YxX3q?f.Gk?OJxR4WUshAKjsB6NA1IJ" | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $client_id_temp, $client_secret_temp
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $tenant_id_temp
##Getworksapce
$workspace = Get-PowerBIWorkspace -Name $workspacename
# GetDataSets
$DatasetResponse = Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets" -Method Get | ConvertFrom-Json
# Get DataSet
$datasets = $DatasetResponse.value
#Iterate all Datasets to find Id of the DummnyDataset
foreach ($dataset in $datasets) {
if ($dataset.name -eq $datasetname) {
$datasetid = $dataset.id;
break;
}
}
## Take Over DataSet
Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.TakeOver" -Method Post
## update data source credentials
#This Api is the recomended for Microsoft
#Retrieve the Dataset Gateway
$BounGateway = Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/datasources" -Method GET | ConvertFrom-Json
$BounGateway
#This call to the Api was commented because the recomendation of microsoft to use another one
#$BounGateway=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.GetBoundGatewayDataSources" -Method GET | ConvertFrom-Json
$UpdateUserCredential = @{
credentialType ="Basic"
basicCredentials = @{
username= $username
password=$password
}
} | ConvertTo-Json
try
{
$response= Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.value.gatewayId)/datasources/$($BounGateway.value.id)" -Method PATCH -Body $UpdateUserCredential | ConvertFrom-Json
$response
}
catch
{
Write-Host "An error occurred:"
Write-Host $_
}
finally
{
}
#$response
