Pragmatically Change Datasets Data source Credential

[PierreV]

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 ?

[lbendlin]

Have you tried this call?

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

[PierreV · Accepted solution]

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