topic Re: Pragmatically Change Datasets Data source Credential in Developer

Pragmatically Change Datasets Data source Credential

Anonymous — Tue, 30 Jun 2020 14:20:52 GMT

Hi,

I've publish a report into a workspace that we use for development. To migrate the report from the Dev Worspace to an UAT one, I've build a PowerShell script that import the report. In the script, I'm changing the database connection of the dataset to point to the UAT server and database using the report parameters (not a gateway). The issue that I'm now facing is that I also need to change the data source credential of the dataset since the user that we use in UAT is not the same then Dev.

How can I change those information using the API or use User Id and User Password parameters ?

Re: Pragmatically Change Datasets Data source Credential

lbendlin — Wed, 01 Jul 2020 01:20:50 GMT

Have you tried this call?

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources

Re: Pragmatically Change Datasets Data source Credential

Anonymous — Thu, 02 Jul 2020 12:46:03 GMT

Hi,

I been able to change the data source credit using the UpdateDataSource API (https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource).

The trick is to use the Get Datasource (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup) before to retrieve the GatewayId and the DatasourceId link to the Dataset. Even if you didn't declare a Gateway to your Dataset (For direct link to SQL Server in Azure), there is one created in the background and link to a Datasource.

So, after calling the Get Datasource, I have all required information to call the UpdateDataSource and change the user Id and credential to connect to the new connection.

Issue solve.

Thanks