topic Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre in Service

Refresh failure - Data source credentials are missing or invalid. Please update the cre

marktvc — Mon, 11 Sep 2023 03:14:31 GMT

I am getting this error with a dataflow refresh.

Data source credentials are missing or invalid. Please update the credentials for SQL in dataflows settings page and try again.

it is intermitant and appears at different points of the refresh. The SQL server is on-prem and data being accessed via the BI Gateway.

Any advice... or diagnostic thoughts would be greatful.

Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre

lbendlin — Mon, 11 Sep 2023 23:28:51 GMT

What happens when you update the credentials as requested?

Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre

marktvc — Mon, 11 Sep 2023 23:47:45 GMT

I have re-entered the credentials assocaited with SQL connection, but we are still getting the occasional failure. This shows the pattern of success/faillures

This is what the report looks like on 2 different failures

Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre

lbendlin — Mon, 11 Sep 2023 23:47:14 GMT

Assuming you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre

sergej_og — Tue, 12 Sep 2023 09:53:14 GMT

I guess your on-prem SQL is running 24/7 and is always accessable? No periodic maintenance or traffic restrictions in the main working time (just an idea)? I know about such traffic restrictions. We do it also in some cases.

Maybe you have too much parallel traffic where CPU of your gateway can´t handle it at the moment.

Your updates are succesful in earlier hours and after closing time.

Regards

Re: Refresh failure - Data source credentials are missing or invalid. Please update the cre

marktvc — Tue, 12 Sep 2023 17:33:15 GMT

I am looking to review this SQL side of this. At the moment I don't have necessary access to confirm.