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.
Good morning, I need help about the On-Premise gateway personal. Approximately 45 days ago, I am having a problem with de automatic update. Sometimes during the week, the problem below happens showing the folloyng message:
"Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: MASCARA.
Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID da atividade: 9f699404-e246-42cc-abad-dbf546a6c1f2
Solicitar ID: 0fe69656-6a39-4297-8f9c-d5b818310c23
Hora: 2023-10-06 16:32:02Z "
To try to fix this problem I did this things:
- Update the gateway On-premise for the last version in the Server;
- Update the Oracle x Power BI client for the last version;
- I increased the parameter the timeout the PBX files for 600 seconds;
- I reviewed the network and anti-virus settings;
- I changed the settings the Oracle Database about the simultaneous connections;
PS: Remembering this problem happens only sometimes, not all the time. For example, at the last week it happened 3 times. Total updates for the week are 14 (twice a day).
Thanks 🙂
Hi @TI_Cinex
From the error it appears that at some points the Gateway cannot connect to the Oracle server. I would have a ping running on the gateway server to see if connectivity drops out?
Hi @GilbertQ ,
So, I already did tests at the network server and we don't have connections drops between the Power BI Gateway server and the Oracle Server. But you are right, apparently the Gateway drop connection with the Oracle database.
Thanks!
Ok thanks, I would chat to your network admin!
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.