Power BI On Premises Scheduled Refresh issue

Question

Hello,&nbsp;I am trying to get a report to refresh using scheduled refresh but i keep getting this message:Credentials are required to connect to the sql source.&nbsp;Things I have tried:in data sources&nbsp; under windows authentication, putting in my user ID /password. clicking test connection and I get a result of connected successfully"in data sources under windows authentication, putting in our data access userid /password clicking test connection and getting a "result of connected successfully"Opening up the report&nbsp;tried using "use my current credentials" under windows, tried using both my userID and the default data username neither of them worked&nbsp;tried putting them in under database. no luck.&nbsp;&nbsp;Part of the problem is that i am not sure of how the data connections work for on premises power bi as they are quite a bit different than ssrs. I have tried to find some instructions, but no luck yet.&nbsp;Anyone have any ideas what my issue might be? Or can direct me to a source for simple instructions how to set up scheduled refresh for an on premises powerbi report that connects to sql server?&nbsp;

lzy0 · Answer

123123

anonymous · Answer

How many data sources do you have ?. Because i have noticed that, if i have more than one in the "Data sources" tab, i have to enter my credentials &gt; test connection &gt; save. I have to do this for all data sources seperately and save. doing all at once, gives me that error also.&nbsp;One other thing you can do is, On the report server, open the report server config manager, select "Execution account" and enter your details there . save and restart.&nbsp;*Please mark this as soution if that helped

odi3 · Answer

Sorry, this is a duplicate post.

anonymous · Answer

Sorry, I posted a Duplicate answer

Forum Discussion

Related content

Schedule refresh

Schedule refresh

Scheduled Refresh Failure

Power BI - Schedule refresh

Scheduled Refresh