Power BI Enterprise Gateway Fails with Unknown error

[Padmanaban]

Our Enterprise Gateway fails with the error "Unknown error in Enterprise Gateway" (see below ) it is connecting to our on perm SSAS Tabular model and fails after a 30 mins to an hour of normal usage.

We recently installed Power BI Enterprise Gateway (moving from Power BI Analysis service connector which is now uninstalled)after which the Power BI fails with the following error "Unknown error in Enterprise Gateway" Error Code DM_GWPipeline_UnknownError, Moreover we could not see any event log for the Enterpise Gateway logged. The on prem analysis service remains functional but the gateway errors out. If we restart the analysis service server the enterpirse gateway becomes functional and Power BI works fine for 30 mins to an hour works and error repeats.

P.S: We checked the ports and all are working fine.

[Anonymous · Accepted solution]

Turns out when we started using the Effective Username permission in the gateway it required the gateway service account to have Server Admin permission and not just SSAS Instance Admin permission. When we granted this permission to the server the problem appears to be ressolved.

[ankitpatira]

@Padmanaban I found below information on the error you're getting. Did you checked logs in the mentioned directory.

I would suggest you use this guide to troubleshoot.

[Padmanaban]

Hey Ankitpatira,

As mentioned in the post we could not see any logs in the mentioned directory Application and Services Logs->Power BI Gateway - Enterprise Service.

[dimazaid]

Hello,
You can find the Logs here: 

C:\Users\PBIEgwService\AppData\Local\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway*.log

Please send it to hybridbi@microsoft.com so we could take a look at what's going on.
Thanks,
Dimah

[Padmanaban]

As a temporary solution we rolled back to the Enterprise Gateway Feb release and we haven’t received the error mentioned in the past log for three days since rolling back. We followed the same installation steps each time and SSAS environment has remain unchanged.