Forum Discussion

nicolajb's avatar
nicolajb
Frequent Visitor
10 years ago

Changing Service account for Enterprise Gateway (when re-installing)

Hi

I have a problem with the Enterprise Gateway.

Situation:

Some time ago the gateway was installed on the same server as the SQL Server (2014). The gateway was configured with a service account named svc_powerbi_dev. Everything worked fine but we went into production with the setup and wanted to change the service account used for the gateway.

 

As I can’t find out where to do that I have now done this instead:

  • Uninstalled the gateway
  • Removed the gateway from powerbi.com
  • Installed the gateway again using another account when installing and signing into powerbi.com
  • configured data sources

 

Result is that when I upload new reports to powerbi.com that connects to a tabular cube (live connection) everything works fine, until I force a refresh or wait for the automatic refresh (usually after an hour).

When I check the log I find this:

[…]data source=dbserver\ssas;initial catalog=Test;cube=Test;sspropinitappname=PowerBI;effectiveusername=svc_powerbi_dev@[my domain];connect timeout=60:[Windows] Encrypted Credential information omitted</pi>][…]

And

[…][1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:  The user name or password is incorrect.[…]

 

The svc_powerbi_dev user has been deleted from the AD. I have even tried to create a new account with the same name with no luck.

So… the question is how I tell power BI to stop using this old account.

 

Hope someone can give me a hint

Thx

Nicolaj

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    nicolajb I've never tried this, but since the Power BI Enterprise Gateway runs as a Windows Service, are the credentials still tied to it?

    You can verify this by navigating to Services - Power BI Enterprise Gateway Service - Properties - Log On

    Is your new credential there or the old one?

     

    Maybe the uninstall didn't delete the service portion? - Just throwing out some ideas.

    • nicolajb's avatar
      nicolajb
      Frequent Visitor
      10 years ago

      Well, I had a look at that a few hours ago :-)

      The gateway service is running under the PBIEgwService account so as far as i understand it is not related to this.

       

      So far i think the problem is the data source that I creat on powerbi.com. It seems to be reusing the credentials on the old data source. 

      When i create the data source i enter the credentials that i want it to use and everything works fint. If I click "Test all connections" it also works. If I enter the credentials of the old account it doesn't work (I can't save the data source if the credentials doesn't work).

       

      To my knowledge, these credentials are the ones that should be used when the data sets are refreshed..... It seems to be using the old credentials.

      • leonardmurphy's avatar
        leonardmurphy
        Icon for Skilled Sharer rankSkilled Sharer
        10 years ago

        Uninstalling the Enterprise Gateway does not remove all the files & folders associated to the Enterprise Gateway. This means that when you go to install it again, it might not be as clean an install as you thought it was.

         

        Folders include:

         

        C:\Users\[name]\AppData\Local\Microsoft\Power BI Enterprise Gateway

        C:\Program Files\Power BI Enterprise Gateway

         

        Perhaps try uninstalling, deleting those folders, then reinstalling.

         

        (Just a suggestion, I don't promise this will work for your situation as I've never encountered what you're describing, but I had an issue where it seemed like my old configuration was being remembered and I thought it was because of something saved by the website, but it turned out to be this)