Skip to main content

Power BI

New

Update Credentials of Dataset using API

Vote (30) 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

92673abc c53a-4bda-a8de-1a9d5f03e5d1 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

478f7fc9 7ad2-4ceb-a589-4f8ae413b231 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

a0aeabda 4a7a-4f45-9743-973a0b817965 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.