failed to refresh report with message ImpersonationErrors

[taglud]

hello, i used a sql statement to connect to sql server DB.

i am able to refresh the report on my laptop.

but when i publish the report and try to refresh it online.

it failed with this error :

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","pbi.error":{"code":"DM_GWPipeline_Gateway_ImpersonationError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: -name of the table-.
thank you for your help and advise.

[v-yetao1-msft]

Hi @taglud 

Which connection mode you used when you connect to SQL DB ? When you add SQL data source in Manage gateways , can you configure it successfully ? 

Best Regards,
Community Support Team _ Ailsa Tao