Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
karthiknc
Frequent Visitor

power-bi gateways update datasource

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

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.