On-Premises data gateways

[Alexandru123456]

Dear All,

For a few months now I have been running into an On-Premise data gateway issue, details below.

2 months ago I started developing reports for the company where I work using Data Flow. To make the connections in the data flow, we used On-Premise data Gateways, offered by the Power BI service. At first glance, everything seems to be ok, but later I noticed that things are worse than I thought, and at the moment I don't understand if I can still use this service. The problem is that once the desktop is disconnected, the sources are not automatically updated as set, but generate an error. And once every 3-5 days the connection with On-Premise data Gateways is generally lost, and I can't update even with the computer turned on, I have to delete On-Premise data Gateways and then install it again, after this again 3 - 5 days with the computer on it works without problems. See below some examples of errors.

Error code: DM_GWPipeline_Client_GatewayUnreachable
Connection error: The gateway is either offline or could not be reached. Please ensure your gateway is online and try again.
Cluster URI: https://api.powerbi.com

Session ID: 12a1c118-043f-4a98-b50e-554ea6777d3c
Request ID: 260b09b7-3483-4812-b1f3-1ef484c848ab
Time: Sun Nov 05 2023 20:36:28 GMT+0200 (Eastern European Standard Time)


Thank you in Advance,
BR,
Alexandru

[GilbertQ]

Hi @Alexandru123456 

Can you also confirm you have got the latest version of the On-Premise gateway installed?

[pmreis]

Hi @Alexandru123456 

Given that reinstalling the On-Premises Data Gateway temporarily resolves the issue, but it reoccurs after a few days, here are a couple of possible root causess.

1. Software Conflicts: There might be software on the host machine that conflicts with the gateway. This could be security software, updates, or other applications that interfere with the gateway's operation over time.

2. Temporary Files or Cache Issues: The gateway might accumulate temporary files or cache data that eventually cause performance issues or conflicts. Reinstalling clears these, which temporarily resolves the problem.

3. Automatic Updates or Changes in the Environment: The host machine or network environment might undergo automatic updates or changes (like security patches, and network configuration changes) that initially don't affect the gateway, but eventually lead to connectivity issues.

4. Resource Leaks or Memory Issues: The gateway software might have a memory leak or resource management issue, leading to gradual degradation in performance until it becomes non-functional.

5. Credential or Security Token Expiration: If there are credentials or security tokens involved that expire or need revalidation, this could explain the periodic failure.
   
   In order to find out which one it is:
   
   

   • Monitor the gateway and host machine for any changes or updates that coincide with the gateway failures.
   • Regularly check and clear temporary files or caches related to the gateway.
   • Investe for any software conflicts or resource management issues.
   • Ensure that all credentials and security tokens are up to date and set to renew as needed.

Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn