Scheduled refresh is disabled due to no credentials for at least one data source - SQL server

[KrzysztofPas]

Hi,

I got a report which have a source on SQL server. When updating data in Power Bi Desktop it works properly, when trying to refresh on published report, it doesn't work - system show information:

"Data source error Scheduled refresh is disabled due to missing credentials for one or more data sources. To restart the refresh, go to the settings page for that dataset and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Action IDe819732a-d888-42ad-8439-db86caff9c73
Request ID5553c803-90c0-9f8d-1d62-bbc9461d4360"

More over, when going into settings, "Data source credentials" is not active (light grey font).

How can I solve it?

Best,

Krzysztof

[KrzysztofPas]

Works, thank you Henry!

[v-henryk-mstf · Accepted solution]

Hi @KrzysztofPas ,

Configure a gateway for this data source and enter the appropriate credential information and then configure the schedule refresh again and it should work.

details stpes:

How to Set Up a Power BI Data Gateway: 3 Easy Steps - Learn | Hevo (hevodata.com)

Or you can refer to a similar solution:

Solved: Re: scheduled refresh not working for web datasour... - Power Platform Community (microsoft....

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

powerbi - Data Source Credentials and Scheduled Refresh greyed out in Power BI Service - Stack Overf...

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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