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

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.