Take OwnerShip of PowerBI Dataset, Change Datasource and then output result

PowerBIDataSourceChangeBatch.ps1

# Connect to PowerBI Service In PowerShell
Connect-PowerBIServiceAccount

# Import the Data File for all the PowerBI Datasets you want to change.
$src = Import-CSV "c:\temp\DataImport.csv"

foreach ($line in $src) {
    $GetURL = "https://api.powerbi.com/v1.0/myorg/groups/$($line.WorkSpaceID)/datasets/$($line.DatasetID)/datasources"
    $TakeOwnURL = "https://api.powerbi.com/v1.0/myorg/groups/$($line.WorkSpaceID)/datasets/$($line.DatasetID)/Default.TakeOver"
    $SubmitURL = "https://api.powerbi.com/v1.0/myorg/groups/$($line.WorkSpaceID)/datasets/$($line.DatasetID)/Default.UpdateDatasources"
    $obj = [PSCustomObject]@{"updateDetails" = @(@{"datasourceSelector" = @{"datasourceType" = "AnalysisServices"; "connectionDetails" = @{"server" = $($line.serverOLD); "database" = $($line.databaseold)}}; "connectionDetails" = @{"server" = $($line.serverNEW); "database" = $($line.databaseNEW)}})} 
    $JSON = $obj | ConvertTo-JSON -Depth 10
   
 # Comment out the lines below once testing complete
    Write-Host $JSON
    Write-Host "Submit URL to be Used: $SubmitURL"
    Write-Host "Takeown URL to be Used: $TakeOwnURL"

# Uncomment out the lines below when ready to implement.
# Invoke-PowerBIRestMethod -Url $TakeOwnURL -Method Post
# Invoke-PowerBIRestMethod -Url $SubmitURL -Method POST -Body $JSON
# Invoke-PowerBIRestMethod -Url $GetURL -Method GET
}