Data source credentials are missing or invalid. Please update credentials dataflows settings

[gquaiotti]

Hi,

I have approximately sixty Dataflows in the same Workspace, extracting data from the same Gateway and the same SQL Server. All of them were working with no issues.

In today's refresh, most of them are showing this error:

Data source credentials are missing or invalid. Please update the credentials for PowerBI in dataflows settings page and try again. [Path: PowerBI]

No changes were made to the Dataflows nor to the SQL Server since the last refresh.

The only change between this refresh and the last one was the Gateway upgrade to March 2021 release 1 (version 3000.77.3).

I just updated to the 3000.77.7 March 2021 release 3, but the error persists.

The only way that I found out to make the Dataflow work was editing and saving the dataflow (with no changes) but this is impractical (and nonsense) as I have a lot of customers with this same structure.

Please, help!

[v-lili6-msft]

hi

I couldn't reproduce this problem, you may try to uninstall and install previous monthly gateway then try it again.

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

also try to re-add the datasource credentials in manage gateway.

Regards,

Lin