topic Help with Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365 CRM in Developer

Help with Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365 CRM

SamInogic — Tue, 14 Jan 2025 07:03:31 GMT

Hello,

We are currently migrating Power BI embedded dashboards from one Dynamics 365 CRM tenant to another. The process involves creating a new Power BI report within a workspace. Since the Dynamics 365 Solution does not support the inclusion of Power BI reports within unmanaged solutions, we have resorted to using PowerShell scripting to manage the migration.

During this migration, we encountered an issue where the report IDs from the original environment remained linked when moving the Power BI embedded dashboards to the new environment. To address this, we have utilized Environment Variables to map the new report and workspace IDs appropriately.

However, we are facing an issue when attempting to edit the Data Source Credentials using PowerShell scripting. Specifically, we are receiving a "Bad Request" error, as shown in the screenshot below.

Here is the PowerShell code we are currently using to edit the Data Source Credentials:

Connect-PowerBIServiceAccount

$accesstoken = Get-PowerBIAccessToken

$patchBody = '"credentialDetails": {

"credentials": {"accessToken":"'+$($accesstoken)+'"},

"encryptedConnection": "Encrypted",

"encryptionAlgorithm": "None",

"privacyLevel": "Organizational",

"useEndUserOAuth2Credentials": true

Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/gateways/9eaed562-e9c2-46e4-91cf-276ed0947b41/datasources/f1181856-de29-4a9a-a555-a0e181cd7898" -Method Patch -Body $patchBody

We would greatly appreciate any guidance or suggestions on resolving this error in the PowerShell scripting process for updating the Data Source Credentials.

Thanks!

Re: Help with Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365

lbendlin — Tue, 14 Jan 2025 15:21:21 GMT

That's patching the credentials for the gateway connection, not for the semantic model?

Re: Help with Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365

Anonymous — Wed, 15 Jan 2025 09:32:50 GMT

Hi @SamInogic ,

Could you please provide the following info for the further troubleshooting?

Whether the access token $accesstoken is being retrieved correctly and is valid?
Whether the gateway and data source IDs used in the endpoint URL are correct and accessible within the new tenant?
Whether the account you are using has the necessary permissions for updating data source credential?

# Connect to the Power BI Service
Connect-PowerBIServiceAccount

# Get Access Token
$accesstoken = Get-PowerBIAccessToken

# Construct the request body
$patchBody = @{
"credentialDetails" = @{
"credentials" = @{
"accessToken" = $accesstoken
}
"encryptedConnection" = "Encrypted"
"encryptionAlgorithm" = "None"
"privacyLevel" = "Organizational"
"useEndUserOAuth2Credentials" = $true
}
}

# Convert the request body to JSON
$jsonBody = $patchBody | ConvertTo-Json -Depth 10

# API Endpoint (replace with your specific gateway and data source ID)
$apiUrl = "https://api.powerbi.com/v1.0/myorg/gateways/9eaed562-e9c2-46e4-91cf-276ed0947b41/datasources/f118185..."

# Send the PATCH request
Invoke-PowerBIRestMethod -Url $apiUrl -Method Patch -Body $jsonBody -ContentType "application/json"

Best Regards

Re: Help with Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365

SamInogic — Fri, 17 Jan 2025 12:41:15 GMT

Hi,

Thanks so much for all your help and suggestions. After trying the different recommendations, we followed these steps, and it resolved the issue:

$body = @{

"credentialDetails" = @{

"credentialType" = "OAuth2"

"encryptedConnection" = "Encrypted"

"encryptionAlgorithm" = "None"

"privacyLevel" = "Organizational"

"useCallerAADIdentity" = $true

}

# Convert the body to JSON format

$jsonBody = $body | ConvertTo-Json -Depth 5

Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/gateways/$($datasource.GatewayId)/datasources/$($datasource.DatasourceId)" -Method PATCH -Body $jsonBody

I appreciate the time you all took to assist me.

Thanks!