Forum Discussion
SCHEDULED REFRESH ERROR
I have searched for any resolutions regarding scheduled refresh errors but haven't read any. I am getting the following: Credentials are required to connect to the SQL source. The exception was...
I solved a similar issue recently with a very similar error message.
In that case, one of the data sources in the report tried to connect at the server level, then the second step connected to the specific database/table. The account we use on our server only had permissions against the specific database therefore the refresh was failing. Everything worked when opening the report in PBI Desktop, as analysts have read permissions at the server level, so the issue was not obvious to find.
Not sure if this helps in your case, good luck in fixing the issue!