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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
6 | |
5 | |
4 |