How to edit datasource credentials of imported PBIX file - Power BI API?

[Anonymous]

I have problem with credentials of datasource. I use .NET library PowerBI.API, I´m importing PBIX file, which has connection to Excel file. I have installed On-Premises Data Gateway. When file is imported, I can´t refresh dataset because the credentials are invalid.

When I click on Edit credentials, it show this.

I click on Sign in and refreshing works fine. But I need make it by API. I tried many ways, but nothing works.

I will be happy for any advice.

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your screenshot, I know that you are using Personal Gateway. As far as I know, Power BI doesn't support us to configure data source credential for Personal Gateway by Rest API. I think use "Edit Credential" option in Power BI Service should be the best workaround to update the credential. 

Or you can download Standard om-premise data gateway  .

Standard on-premise data gateway has many differences with Personal Gateway.

For reference:On-premises data gateway vs. on-premises data gateway (personal mode)

After you download standard on-premises data gateway, you can try to create data source or update data source credential by Power BI Rest API.

For reference:Power BI Rest API - Gateways

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.

[Hariharan_R]

Hi - if you want to use gateway then you need to configure the excel datasource in gateway and then you can map it in Power BI dataset settings. You dont need to configure the credentials for each dataset. Configure it on Power BI data gateway data source.

Use your windows authentication option.

Thanks

Hari