Update Dataset Connections using Power BI APIs

Your JSON request body should look like this:

{
"updateDetails": [
{
"datasourceType": "Sql",
"connectionDetails": {
"database": "NAME_OF_DATABASE",
"server": "NAME_OF_SERVER.database.windows.net"
},
"datasourceId": "XYZ123"
}
]
}

 For cloud sources like Azure SQL Database, leave this field empty or remove it. The API does not require a gateway for cloud connections.

PowerShell Script:

# Parameters
$workspaceId = "YOUR_WORKSPACE_ID"
$datasetId = "YOUR_DATASET_ID"
$url = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/datasets/$datasetId/Default.UpdateDatasources"

# Connection Details
$ConnectionDetailsObject = @{
    updateDetails = @(
        @{
            datasourceType = "Sql"
            connectionDetails = @{
                database = "NAME_OF_DATABASE"
                server = "NAME_OF_SERVER.database.windows.net"
            }
        }
    )
}

# Convert to JSON and Make the API Call
Invoke-PowerBIRestMethod -Url $url -Method Post -Body ($ConnectionDetailsObject | ConvertTo-Json -Depth 10) -ContentType "application/json"

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.