Scheduled Refresh Not Working

[SimonSeez]

Hello, 

I set up a scheduled refresh but I always get this error below when the report tries to run . Currently I am forced to manually refresh the report. I have already connected the Power BI datasource successfully to the CRM environment where the data is coming from. So I am surprised why the refresh does  not work. 

[0] -1055784932: Credentials are required to connect to the SQL source. (Source at 11.1.11.11,1111;MSCRM.). The exception was raised by the IDbCommand interface. 

[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. 

Best Regards, 

[KBO]

Hi @SimonSeez ,

which type of Power BI do you use? 

1) On Premises - Power BI Report Server

-> You need to write down your credentials (or common is a technical user) under manage -> data source 

2) Cloud - Power BI Service

-> If you use the Service than be sure that you don't need any gateway and that your credantials are also set under Settings -> data source credentials

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!