Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

I've just had the same issue and was able to fix it and hope the same steps help you to fix your issue too:

 

I opened the report in Power BI Desktop and went to Power Query (edit queries) and clicked on 'Data Source Settings' in the ribbon. I clicked on 'Edit Permissions' on the source in question and noticed I'd set 'Alternate' credentials rather than Windows credentials (at the time my own credentials weren't working. I set this back to Windows credentials and refreshed everything in Power Query and then, for belts and braces, in PBIRS I deleted the report (be careful if you want to save the previous auditing etc as this will get lost if deleting) and added it back in along with the data source credentials and schedule. Voila! It refreshed successfully!

 

Hope this helps you too.