Skip to main content

Power BI

Needs Votes

Update Credentials of Dataset using API

Vote (56) Share
Dan Malagari's profile image

Dan Malagari on 07 Mar 2017 06:28:58

It is imperative to have parity between the UI controls in the Power BI web interface and the REST API.

One clear example of this is the ability to edit/update data source credentials. The API currently grants the ability to update the connection string of a data source, but not the credentials. Additionally, we're able to edit the credentials of a data gateway and the associated data sources, but not the full range of data sources available to Power BI (e.g. Azure SQL, SQL Server, etc).

This will allow the deployment of .PBIX files to be fully automated (aside from some other suggestions that request parameters to be added to the API, which is also a great idea). Right now, I'm able to import a .PBIX file through the API, but still require some sort of user intervention in the web interface to update the data source credentials. For more sensitive datasets, this can't fly - we're trying to obfuscate the credentials from the users by building an application to manage the deployment for them.

Comments (4)
Dan Malagari's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:13:05

RE: Update Credentials of Dataset using API

Is there any update of this feature will be available, because this will allow us better support in devOps pipelines

Dan Malagari's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:36

RE: Update Credentials of Dataset using API

Updating the connection string for 'imported mode' is needed.

Dan Malagari's profile image Profile Picture

Power BI User on 05 Jul 2020 22:56:28

RE: Update Credentials of Dataset using API

When this feature will be available in PowerBI API service?

Dan Malagari's profile image Profile Picture

Dan Malagari on 05 Jul 2020 22:42:53

RE: Update Credentials of Dataset using API

To add clarification, this is for the PowerBI.com REST API, not the Embedded API.