Forum Discussion

ivanferr92's avatar
ivanferr92
New Member
6 years ago
Solved

Power BI REST API Update datasource credentials

Hi,   Is it possible to use the Powerbi REST API to update the login credentials to a dataset? I found something similar for gateway-managed dataset: https://docs.microsoft.com/en-us/rest/api/powe...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI ivanferr92,

    I also check the rest API documents but not found any apis to direct operate the data source credentials. (some of API can update the connection strings but they not mention/contains any parameters to operate on data credentials)
    I guess power bi service may not want to share them due to security reasons.

    Regards,

    Xiaoxin Sheng

xli629b's avatar
xli629b
Helper II
4 years ago

When there is no actual gateway, and it's a cloud datasource, I'm able to find a gateway ID as you say, interestingly enough.

However, when I try to update the datasource using this gateway ID + datasource ID, I always get an error: 400 DM_GWPipeline_Gateway_DataSourceAccessError. I also can't lookup this gateway using the get gateway method and retrieve its public key, which I need in order to encrypt the credentials.

nishanttayal's avatar
nishanttayal
Frequent Visitor
3 years ago

Hi, Are you able to find the solution of this problem?