Power BI report not refreshing: The on-premises data gateway's service account failed to impersonate

[samanzoor]

I have a report that was refreshing perfectly (was set for scheduled refresh in Power BI Service) until I started getting the following error EVEN WITH REFRESH NOW:

The on-premises data gateway's service account failed to impersonate the user.

My credentials seem to be alright; nothing has changed in the back end. Also, I have tried looking online to mitigate the issue but could not find any relevant solutions.

Please advise!!

[v-lid-msft]

Hi @samanzoor ,

Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[v-lid-msft]

Hi @samanzoor ,

What is the version of your on-premises data gateway? Are you using the standard mode of gateway? Could you please check if the datasets in different workspace map to the same data source of gateway?

Please also refer to this solution in this similar thread:

https://community.powerbi.com/t5/Service/the-on-premises-data-gateway-s-service-account-failed-to/m-...

Best regards,