Forum Discussion

VSrujana's avatar
VSrujana
Frequent Visitor
6 years ago

Power Bi Service - Scheduled Refresh fails irregularly

I have dataset connected to Azure SQL server in composite model.

The import datasets are scheduled for 48 times refreshes per day . ( Premium capacity).

 

I get the following error once after every 4-5  successfull refreshes . 

Failure details: COM error: mscorlib, A task was canceled.. A connection could not be made to the data source with the Name '.....'.

However , there is no issue in on demand refresh , even when continously refreshed for 6 times.

 

 

Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    It could possibly be an issue with the scheduling within Power BI

    If the issue still persists I would suggest logging a support call for more detailed information.
  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi VSrujana ,

     

    I can't reproduce your problem, please create support ticket .

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I had the same error.  

    Scheduled Refresh Error:  COM error: mscorlib, A task was canceled.. A connection could not be made to the data source with the Name of…

    Please share any results or the cause would be appreicated.