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.
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.
Solved! Go to 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.
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.
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.