Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

failed to refresh report with message ImpersonationErrors

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.

Status: Needs Info

Hi @Anonymous 

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @Anonymous 

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