Scheduled Refresh Not Working

SimonSeez — Wed, 08 Jul 2020 11:10:55 GMT

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,

Re: Scheduled Refresh Not Working

KBO — Sun, 19 Jul 2020 11:18:18 GMT

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!

topic Scheduled Refresh Not Working in Report Server

Scheduled Refresh Not Working

Re: Scheduled Refresh Not Working