SQL server data source refresh in app.powerbi.com

[rj7]

I have used microsoft sql server import connection to powerbi desktop. Upon publishing the file online to app.powerbi.com, I get an error that '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 refres'.
I followed powerbi documentation and in advanced editor i found 'Source = Sql.Databases' in the datasource query.  

How do I enable refresh then? 

[Anonymous]

Hi  @rj7 ,

You can go to the "Data Source credentials" to re-edit or add the Dataset credentials. Check that all data source credentials have been entered and validated.

The dataset owner or a workspace admin (taking control of the dataset) can edit the credentials for the source.

This is the related document, you can view this content:

Solved: Scheduled refresh is disabled because at least one... - Microsoft Fabric Community

Solved: Scheduled refresh is disabled because at least one... - Microsoft Fabric Community

Solved: Data Source Credentials - not being able to enter - Microsoft Fabric Community

Best Regards,

Liu Yang

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