cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Padmanaban Frequent Visitor
Frequent Visitor

Power BI Enterprise Gateway Fails with Unknown error

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.Enterpise Gateway.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions
nerickson Visitor
Visitor

Re: Power BI Enterprise Gateway Fails with Unknown error

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.

 

5 REPLIES 5
Super User
Super User

Re: Power BI Enterprise Gateway Fails with Unknown error

@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.

 

Capture.PNG

Padmanaban Frequent Visitor
Frequent Visitor

Re: Power BI Enterprise Gateway Fails with Unknown error

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.

Event Log.png

Power BI Team dimazaid
Power BI Team

Re: Power BI Enterprise Gateway Fails with Unknown error

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 Frequent Visitor
Frequent Visitor

Re: Power BI Enterprise Gateway Fails with Unknown error

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.

nerickson Visitor
Visitor

Re: Power BI Enterprise Gateway Fails with Unknown error

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.