Error while trying to build on premise gateway

[Anonymous]

I am getting below error while trying to refresh dashboard, This error occurred in on-premise

gateway:

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","pbi.error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Won_count.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 60fc5802-c4ea-4f46-b602-77b43167a317
Request ID: 62a5536d-dd1b-53ae-b5b5-c8cabe398f94
Time: 2020-07-16 15:52:55Z

sharing the data connection setting in the gateway :

[v-easonf-msft]

Hi , @Anonymous 

Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

Hi @Anonymous ,

"Impersonation" error is often about authentication.  Are you using the right userid for the Gateway?  That userid has permissions?  Is that a userid that is a domain user?

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous]

Hi @collinq 

Can we edit/delete an existing connection under the gateway? 

I am using the windows login that I use to login into the sql server still it shows authentication error.

[collinq]

Hi @Anonymous ,

Yes, you can delete and re-add a gateway.  BUT, you will probably have to re-link that gateway on your scheduled refreshes / reports that are using that gateway.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[v-easonf-msft]

Hi, @Anonymous 

Your  gateway does not seem to have any problems, it seems like just  an error is reported when refreshing report.

Can it be refreshed on the PowerBi  desktop?

Has the table name,column name or structure of the table been changed in the database?（for example:A column name was changed  from lowcase to uppercase,a column in the table is removed/added  ）

Please ensure that the tables structure of the data source is consistent with the table structure of the dataset on the service, so that the data can be refreshed .

I noticed this "Table: Won_count" in the error message,  it may be a table in the database.Please check whether  it has be modified.

Best Regards,
Community Support Team _ Eason