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
    Solution 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
    Community 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?