Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am getting the below error message when datasets are refreshing. Looking at the dataset in the service I see a a status of the gateway of "Running on PBI". I can refresh from the desktop app and publish the dataset with new data, but the scheduled refreshes are all failing. It has also been refreshing fine for the past several weeks. This is also occurring with another dataset I have.
Assistance would be greatly appreciated!
Last refresh failed: Sun Feb 16 2020 04:44:54 GMT-0700 (MST)
The on-premises data gateway's service account failed to impersonate the user.
Solved! Go to Solution.
Hi, @Razorbx13
Based on my research, the FailedToImpersonateUserException happens if you're unable to impersonate on behalf of another user. This error could also happen if the account you're trying to impersonate is from another domain than the one the gateway service domain is on. This is a limitation. You may try the following solutions:
For further information, please refer to the following links.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For further information, please refer to the link .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Razorbx13
Based on my research, the FailedToImpersonateUserException happens if you're unable to impersonate on behalf of another user. This error could also happen if the account you're trying to impersonate is from another domain than the one the gateway service domain is on. This is a limitation. You may try the following solutions:
For further information, please refer to the following links.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For further information, please refer to the link .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Usually this error comes because of the wrong username password or the access issues.
Could you please check below points :
Can you please ensure this Data Source crentials has no issues too.
P.S. > I had the same issue where I have used username and password on the gateway but need to update that to Domain\username . Hope this helps.
Regards
Mahak
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |