topic Re: AccesUnauthorized Gateway in Developer

AccesUnauthorized Gateway

Anonymous — Wed, 14 Jul 2021 07:33:34 GMT

Hello Guys,

I'm facing a huge problem about refreshing my dashboards on the app.powerbi. The gateway system is not working well and showing the follow screen:

with the same credential, i can refresh the report at PBI Desktop
and at the last 2 week, this error suddendly appear.

i've already check whitelist at server gateway to database, and this is not the rootcause

Re: AccesUnauthorized Gateway

Anonymous — Thu, 15 Jul 2021 07:25:58 GMT

can someone give the solution for this ?

Re: AccesUnauthorized Gateway

V-lianl-msft — Fri, 16 Jul 2021 05:12:27 GMT

In this secnario, I suggest you check the logs first.

You can see On-premises data gateway service logs under:

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

And On-premises data gateway service event logs under Application and Services Logs.

Then please restart enterprise gateway service via command:

net stop PBIEgwService

net start PBIEgwService

If the issue still persists, I suggest you uninstall Enterprise gateway and install latest version On-premises data gateway. For more details, please see: Troubleshooting the On-Premises Data Gateway

Re: AccesUnauthorized Gateway

Anonymous — Fri, 16 Jul 2021 07:10:48 GMT

for the uninstall and reinstall proses, theres any possible that i'll lose all my gateway ? and must be add all gateway from start @V-lianl-msft

Re: AccesUnauthorized Gateway

V-lianl-msft — Fri, 16 Jul 2021 07:37:14 GMT

If you're restoring the gateway on the computer that has the original gateway installation, you must first uninstall the gateway on that computer.

If you remove or delete a gateway cluster in any of the cloud services, you will not be able to restore it.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-migrate