Scheduled refresh is disabled because at least one data source is missing credentials.

[marquesjef]

Published a dashboard with my PRO account, but when updating through the platform, the following error appears:

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

This dashboard consumes data from a MySQL database, does not have a gateway, and in its settings, the option for database credentials is disabled.

Does anyone know how to solve it?"

[v-jianpeng-msft · Accepted solution]

Hi, @marquesjef 

LBENDLIN answered very well, you need a gateway. Power Bi Service is connected to your data source through the gateway. Below I will add some detailed steps:

1.Download and install the Power BI Standard Gateway. For detailed installation steps, you can click the connection below:

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

2.When you configure the local gateway, you need to connect to your semantic model through this gateway in Power BI Service.

Click this small gear in the upper right corner

Click New to create a new connection

Select your gateway in the Gateway Cluster Name, select mysql in Connection Type, and then fill in your MySQL Server, DataBase, Authentication.

3.When you successfully configure the Connection, you can use this gateway connection for your semantic model through the following steps:

Through the above steps, you can configure the gateway connection to your semantic model. After successful configuration, you can use the schedule refresh function normally. For more details, please click the related connection below:

Use the on-premises data gateway app | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[marquesjef]

I managed to download the Gateway, but when configuring it within the Power BI platform, I encounter an issue. In the authentication field, it only requests one password, but in our company's architecture, there is an SSH port (which has a password) connecting the gateway to AWS, and from AWS to MySQL, there is another connection password. I would need to provide these two passwords, but the Power BI platform only asks for one. Do you know how to solve this issue?

[lbendlin]

Power BI expects "line of sight"  to the data source. It cannot handle connection open/close  or VPN management or any additional steps.

Your gateway needs to reside in AWS as well.

[marquesjef]

In my case, my server is Linux. Do you know any solution for this situation?

[lbendlin]

Set up a WS2019 VM in AWS.

[marquesjef]

Is there a Linux version of the gateway?

[lbendlin]

No, only Windows. WS2019 preferred

[lbendlin]

Check the data source settings in your PBIX. Most likely a rogue data dource that needs a gateway.

By the way, your MySQL database very likely needs a gateway anyway.