Failed to update data source credentials

[edlaw]

I am connecting a Power BI report to a MySQL database. It works well with PowerBI (desktop) data refresh manually.

Then, I tried to use MS Power Automate to schedule regular data refresh automatically. The refresh tests seemed successful.

But the attempts actually failed as shown in the Power BI (web) data refresh history. The error was "at least one data source is missing credentials".

However, when I entered the credentials, errors were prompted as follows. How can I solve this issue? Many thanks.

[MFelix]

Hi @edlaw ,

Change the privacy levels to Organization that should do the trick.

[edlaw]

Hi Miguel

Thanks for the suggestion. But got the same error.

[MFelix]

Have you tried any other option than the basic authentication method?

[edlaw]

Only "Basic" Authentication method is available.

[MFelix]

I suggest you place this on the issues part of the forum, they are quick to answer this type of questions there.

[edlaw]

Many thanks, MFelix!