DM_GWPipeline_Gateway_ImpersonationError on refreshing dataset

[Anonymous]

Hi,

I have remote SQL server on server and I installed there On-premise data gateway, everything works there great, but When I'm trying to refresh my dataset which is connected to that gateway every time with my database one table is showing as error. I cannot understand what happens. In "Manage gateways" everything looks good all connections are Success.

Data source error:	{"error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","pbi.error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: tr_category.
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	54fb4191-2c51-4ab1-a6de-ee2a7d5f404a
Request ID:	2bcfe0bc-3303-c906-f269-6e95adbdba42
Time:	2020-04-27 06:27:36Z

Here is the table allways changes with empclass, country and etc.

Please note that the copy of this Server I have in my localhost. When I'm running gateway from my computer not from server and it gets the data from my localhost server it works perfect.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

There is a similar thread about the issue. And some users have resolved it by the following solutions. Please have a try to check if they work for you.