Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Error

Hi,

 

I hope someone can help me understand the two PowerBI Errors we have encountered. The error shows in both scheduled and manual data refresh.

 

{'errorCode':'ProcessingError','errorDescription':'The command has been canceled.. The exception was raised by the IDbCommand interface.'}

 

{'errorCode':'ProcessingError','errorDescription':'The command has been canceled.. The exception was raised by the IDataReader interface.'}

 

Thanks in advance.

  • Hi Anonymous ,

    The IDbCommand interface is used to represent an SQL statement that is executed while connected to a data source, and IDataReader Interface is used to provide a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source.

    Based on the above error message, this problem should occur at the Gateway Client end, I would suggest you checking the Gateway error log to get more information: https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshooting-power-bi-personal-gateway

    Best Regards,

    Teige

3 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous ,

    The IDbCommand interface is used to represent an SQL statement that is executed while connected to a data source, and IDataReader Interface is used to provide a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source.

    Based on the above error message, this problem should occur at the Gateway Client end, I would suggest you checking the Gateway error log to get more information: https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshooting-power-bi-personal-gateway

    Best Regards,

    Teige

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, TeigeGao the info.

       

      How will I troubleshoot if the error only occurs in the scheduled refresh?

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    Anonymous   can't say, but what you can do is if you have the original power bi desktop version and if you update it manually what happens?