topic Re: Data source loosing credentials after Dataset parameter updated via API in Developer

Data source loosing credentials after Dataset parameter updated via API

kroman — Wed, 18 Dec 2024 11:18:42 GMT

Hi All

I noticed that if I update Power BI Dataset parameter via API, it loses data source credentials, so I have to go to Power BI service and manualy update those credentials

Any idea how to sort it?

Thanks

Re: Data source loosing credentials after Dataset parameter updated via API

NandanHegde — Thu, 19 Dec 2024 04:25:53 GMT

You can even use REST API to update the credentails :

https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource

Re: Data source loosing credentials after Dataset parameter updated via API

kroman — Thu, 19 Dec 2024 09:37:33 GMT

Thats for Gateways, which we dont use

Re: Data source loosing credentials after Dataset parameter updated via API

Anonymous — Fri, 20 Dec 2024 09:26:30 GMT

Hi @kroman ,

I think you may try to update datasource for datasets.

For reference:
Datasets - Update Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data source loosing credentials after Dataset parameter updated via API

kroman — Mon, 23 Dec 2024 15:42:05 GMT

Tryed it - doing the same thing, removing datasource credentials 😞