Connection over SSH from Power BI 1Pro account to My SQL

[Vinay_Sagar]

While trying to setup daily refresh in power BO server I am facing below error. Please resolve my issue.

Data source error: 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.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: abad4253-842e-4f1e-93e1-0edb55c07db5
Request ID: 3f31437a-1934-604b-82be-16d3449706b4
Time: 2024-04-25 12:45:24Z

[Vinay_Sagar]

Yes I installed gateway, After installation only I tried to setup daily refresh

[Anonymous]

Hi @Vinay_Sagar ,

Based on your description, it seems that you want to use the data source MySQL to refresh the report automatically. Since MySQL is a local data source, a gateway is required.

You can refer to the following official documentation to configure scheduled refresh:

Manage your data source - import and scheduled refresh - Power BI | Microsoft Learn

Power Query MySQL database connector - Power Query | Microsoft Learn

Best Regards,
Adamk Kong

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