Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello All,
Thanks for reading My Email.
Currently Im trying to configure the Power Bi Dataset using a Service Principle, which is using Common Data Service as Connection DataSource.
I was able to successfully take over the DataSet. But when I try to configure the Datasource using patch request it throwing a 400 Bad Request.
Can Someone point me to the correct direction?
I already did enable API in Tenant settings for entire Organization and provided Power bi adminstrator role to Service Principle .
Below is the Sample Code
Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.value.gatewayId)/datasources/$($BounGateway.value.datasourceId)" -Method PATCH -Body $credentialDetails -VERBOSE
Below is the Body
{
"credentialDetails": {
"credentialType": "OAuth2",
"credentials": "{\"credentialData\":[{\"name\":\"accessToken\", \"value\":\"eyJ0....fwtQ\"}]}",
"encryptedConnection": "Encrypted",
"encryptionAlgorithm": "None",
"privacyLevel": "None"
}
}
Regards
Karthik
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |