dataset partially online, on-premises gateway both online

[reinhard_84f]

Dear all,

set up of a second gateway in the same clusters is done - gateway is online and enabled in the cluster.

both same version: 3000.298.8 - so gateways are online, but...

Dataset (Connectors) only partially online, old one is fine, new one is corrupt; two different laptops, powerbi desktop and connection is fine for SQL and Excel-workbooks, only new connector is not workking - any idea? Same login on windows either...

What have I missed? 

error message:

Error code: InvalidCredentials
Connection error: Invalid credentials
Cluster URI: https://api.powerbi.com
Session ID: 1475b462-98dc-459b-b943-12c6a9808cac
Request ID: 7a9e93f9-7ec6-4023-bd0d-1e26729a9c61
Time: Wed Jan 21 2026 17:04:53 GMT+0100 (Central European Standard Time)
:
fenoPowerBI-RN: Received error payload from gateway service with ID 1428761: <ccon>Die für die Quelle "File" bereitgestellten Anmeldeinformationen sind ungültig. (Quelle unter "\\fe....auf.xlsx".)</ccon>.

[v-prasare]

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

Thanks,

Prashanth

MS fabric community support

[v-prasare]

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

Thanks,

Prashanth

MS fabric community support

[v-prasare · Accepted solution]

Hi @reinhard_84f,

Thanks for reaching out to MS Fabric community support

@GilbertQ& @djurecic, Thanks for your prompt response

To identify whether a specific gateway node is causing the issue, you can temporarily isolate the gateway cluster. Disable or remove one gateway machine from the cluster, and keep only one gateway node active. Once this is done, trigger a dataset refresh. If the refresh succeeds, it indicates that the disabled gateway node is faulty or misconfigured. If the refresh still fails, then the problem is not related to gateway clustering and is more likely due to datasource configuration, credentials, or connectivity issues.

Thanks

Prashanth

MS Fabric community support

[reinhard_84f]

how can i test the gateway ports, the test in on-premesis gateway is not working properly on both machines, could not see any test result available in the log-file, all checks are green.

[GilbertQ]

Hi @reinhard_84f 

Can you ensure that both gateways are connected to the same cluster? From what you are saying, it appears that only one of the servers in the cluster is online.

[reinhard_84f]

Both Gatewas are in the same cluster, both are online, both using same ms account
but only one gateway can connect to the source, neither SQL nor files are possible

via power bi desktop all sources are available.
next step is IT-check of ports...

[djurecic]

Seems like it should would, but I would go through the steps here just to double check everything:

https://radacad.com/the-power-bi-gateway-all-you-need-to-know/