Failed to update data source credentials using web Power BI

[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. Any ideas to help solve this issue (screen dumps are attached)? Many thanks.
• 

[v-xiaoyan-msft]

Hi @edlaw,

Please ensure that the credentials you are entering are correct and have the necessary permissions to access the MySQL database. Double-check the username, password, and any other required connection details.

Check Gateway Configuration,make sure it is properly configured and running. Verify that the gateway is online and that it has access to the MySQL database.

If the above doesn't help, are you using MySQL to create Dataflow as a data source?

Best regards.
Community Support Team_Caitlyn

[edlaw]

Thanks Caitlyn.

• I have switched to using SQL server (Direct Query) and set up an On-premises Data Gateway. Data refresh works well in the "publish from desktop" method and data changes can be reflected in the report real time, even without setting up a scheduled data refresh (under the Semantic models tab => Scheduled refresh and performance optimization).
• However, it takes about an hour for the data to refresh when using the "Embed code -> Publish to web (public)" method. Is it a normal behaviour of the Power BI?