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

paritoshmishra's avatar
paritoshmishra
Icon for Helper I rankHelper I
5 years ago

above code throw "Operation returned an invalid status code 'Unauthorized'  on "client.Gateways.UpdateDatasource"   event thou I have given all powerBI API permission include Tenant.ReadWrite.   I don't use the gateway, Is this the reason for the error?

Andrew-T2's avatar
Andrew-T2
Frequent Visitor
3 years ago

Has anyone been able to solve this datasource update for a cloud (not on-prem) gateway?
In my case I need to update a GCP Service Account on a Google Big Quey datasource on a dataflow. 

 

A
Using the Gateways - Update Datasource "REST API Try It":
If I use the service principal I get a "PowerBINotAuthorizedException",

If I use my own creds, I get an error: DM_GWPipeline_Gateway_DataSourceAccessError.

I have not found an explanation for this in the cloud datasource context.  Does this API work at all for personal, cloud gateway datasources? It seems most of the gateway API's were designed around on-prem gateways.

 
B
Also, trying the same using Powershell, I'm getting a BadRequest (400). How to compile the basic credentials in the request body in PowerShell where the GCP service account key is an entire JSON file full of double quotes which need to be escaped or all enclosed in single quotes?

Any help would be most welcome please.
Also, I'm not sure if I should post this in a new topic?