Forum Discussion

SimonSeez's avatar
SimonSeez
Helper III
6 years ago

Scheduled Refresh Not Working

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, 

Report Server

1 Reply

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    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!