Failed to update data source credentials

[KGolunov]

Keep getting Failed to update data source credentials, I have tried to udpate the report, checked creds in the desktop version, waited for this to resolve itself ans still the same issue. This message is accross multiple connection types and multiple reports, but some reports are workign with no issues. What can I do?

Please note that re-publishing the report as new is not something that I want to do as I would have to inform the whole company that reports have been updated and now they need to re-favour them. 

This is example of an error that I'm getting:

Failed to update data source credentials: Hide details
Activity ID: 23fed9e5-a77d-4df2-8cde-0f4445079dc0
Request ID: 0ec5f976-0b98-ca9f-6b0d-528028eb4961
Status code: 500
Time: Mon Feb 22 2021 08:43:14 GMT+0000 (GMT Standard Time)
Service version: 13.0.15430.58
Client version: 2102.3.04950-train
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net/

[KGolunov]

I'm not sure if you guys are understanding my issue.

I have a on-prem personal gateway set up and getting the Failed to update data source credentials error. I have everything correctly installed and running and still getting this error when trying to update credentials in the power bi web version.  Apart from re-publuhsing reports as brand new, does any one have any other suggestions? 

[v-yangliu-msft]

Hi  @KGolunov 

Please check whether you have installed the latest version of the gateway and whether the gateway is spooling.

Can a new datasource be successfully added in the gateway? 

This is the relevant content of the gateway:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

Best Regards,

Liu Yang

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

[KGolunov]

Still the same issue, have the latest version of the personal gateway and all the nessesary things installed. I can't use the on prem version as I ahve Python scripts in my reports. 

[v-yangliu-msft]

Hi  @KGolunov ,

This is also one of the reasons, you can try it, because we can’t reproduce your scene, if it’s not right, send us an error message

Best Regards,

Liu Yang

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

[v-yangliu-msft]

Hi  @KGolunov ,

What is your data source, what is the authentication method of the input data source.
you can try to delete the data set/report in Power BI and then republish it.

This is the related link, you can check it out:

https://community.powerbi.com/t5/Power-Query/failed-to-update-data-source-credentials/td-p/8555

https://community.powerbi.com/t5/Desktop/Personal-Gateway/m-p/3358

Best Regards,

Liu Yang

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

[KGolunov]

Hi @v-yangliu-msft, 

Thanks, but it's not one report it multiple that are shared with int he company. Republishing is not somethign that I want to do. 

Coudl this be the soltuion? 

https://stackoverflow.com/questions/58689603/failed-to-update-data-source-credentials-the-column-bud...

[v-yangliu-msft]

 Hi  @KGolunov  ,

Currently, it is not supported to implement python script data source through On-premises data gateway in Power BI Service. Python script data source is only applicable to On-premises data gateway (personal mode)

This is related documents, I hope to help you:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

https://community.powerbi.com/t5/Service/Data-Gateway-Configuration-for-Python/td-p/716977

Best Regards,

Liu Yang

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

[KGolunov]

Hi @v-yangliu-msft, I'm not asking if Python is supported in the On-prem gateway, I know it is not.