Forum Discussion

Lidwina's avatar
Lidwina
New Member
6 months ago
Solved

Impala Power BI Service Refresh Failing

I’m experiencing an issue with scheduled refreshes in the Power BI Service for a dataset connected to Cloudera. What’s strange is that I’m getting three different types of errors, even though the refresh runs every 5 minutes and I haven’t changed anything, not the connection string, nor the gateway configuration.

I also heard (though I’m not sure if it’s true) that Microsoft has changed the rules so that scheduled refresh in Power BI Service can no longer be used.
Is that accurate?

Does anyone know the cause or have a solution for this?

Need Help
  • anilelmastasi's avatar
    anilelmastasi
    6 months ago

    Okay I saw SASL in your third screenshot that means you are using Cloudera on-prem.

    There can be more than one reason about these fails. I suggest you to check CPU and RAM of your Server. Also check the log file from here:

    C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway.log

     

    If memory is near 100%, this explains error in your first and second screenshot.

     

    For your third error, if you are using Service principal then check if password expired, if service principal user is still valid and impala access of this account.

     

    If this solved your issue, please mark it as the accepted solution. ✅

4 Replies

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    6 months ago

    Hi Lidwina 

    I wanted to check if you had the opportunity to review the information provided by anilelmastasi . Please feel free to contact us if you have any further questions.


    Thank you.

  • anilelmastasi's avatar
    anilelmastasi
    Super User
    6 months ago

    Hello Lidwina ,

     

    These three fail has different causes and all of seem from Cloudera side. Is your Cloudera on-prem?

    • anilelmastasi's avatar
      anilelmastasi
      Super User
      6 months ago

      Okay I saw SASL in your third screenshot that means you are using Cloudera on-prem.

      There can be more than one reason about these fails. I suggest you to check CPU and RAM of your Server. Also check the log file from here:

      C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway.log

       

      If memory is near 100%, this explains error in your first and second screenshot.

       

      For your third error, if you are using Service principal then check if password expired, if service principal user is still valid and impala access of this account.

       

      If this solved your issue, please mark it as the accepted solution. ✅

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    5 months ago

    Hi Lidwina 

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you