Impala Power BI Service Refresh Failing

[Lidwina]

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?

[v-nmadadi-msft]

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

[v-nmadadi-msft]

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]

Hello @Lidwina ,

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

[anilelmastasi · Accepted solution]

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. ✅