Power BI Personal Gateway, Five Things You Must Know

When we are talking about using a new technology we need to understand it first. Power BI Personal Gateway is not an exception.  Despite you can easily install the Power BI Personal Gateway, knowing the following important points is crucial. I believe the following 5 points are significantly important to prevent you getting into troubles with the installation process as well as using the gateway:

image

  • Power BI Personal Gateway is only available on 64-bit Windows operating systems
  • Once you install Power BI Personal Gateway you don’t need to install another one as just one gateway works for any number of supported data sources
  • You CANNOT install the Power BI Management Gateway on the same machine as Power BI Analysis Services Gateway
  • If you’re trying to install the Power BI Personal Gateway on a network having Active Directory make sure that the account you’re using to install the Power BI Personal Gateway is able to “Logon as a Service”. In some cases the “Logon as a Service” policy is prevented on Active Directory for security reasons. The “Log on as a Service” should be applied to those accounts that are NOT under an Active Directory. So even if you are using a Local Account you should make sure that the local account is added to the local security policy “Log on as a Service”. If the account used to install the Power BI Personal Gateway is banned from the “Log on as a Service” policy you’ll get “Service ‘Data Management Gateway Service’ (DIAHostService) failed to start. Verify that you have sufficient privileges to start system services.” error message.

  • Permission types applied to your Windows account affects how the Power BI Personal Gateway is installed and how it works in Windows. Unlike Microsoft Data Management Gateway which was used to refresh on-premises datasets from Power BI 365, you don’t need to have administrator rights. So when  you logged into Windows:
      • If your Windows account has administrator permissions then the Power BI Personal Gateway will be installed as a “SERVICE”.
        1. As long as the machine and the service are up and running your scheduled refresh will work. So you don’t have to be logged into Windows at refresh time.
        2. If you change your Windows account password then you’ll need to change it in the Power BI Personal Gateway as well.
      • If your Windows account doesn’t have administrator permissions then the Power BI Personal Gateway will be installed as an “APPLICATION”.
        1. Even if the machine hosts the Power BI Personal Gateway is up and running, you still need to be logged into Windows at scheduled refresh time.
        2. As the Power BI Personal Gateway is installed as an application it will always run using the account and password you’re currently logged in with. So if you’re not logged into Windows the data won’t refresh and the scheduled will fail.

6 thoughts on “Power BI Personal Gateway, Five Things You Must Know”

  1. So, if I want to deploy a new dashboard I’ll have to be logged in the production server?
    I’ve never being able to schedule a refresh in a Power BI 2.0 dashboard. Regards

    1. Hi Rodrigo.
      No you don’t need to login to you production server. All you need is to install the gateway on a machine which is always up and running which could be a server, but, it’s not necessary.
      The other point is that the user that you’re using the gateway should have sufficient access rights on the database and the server itself.

      Cheers

      1. Hi Soheil
        But I don’t understand how it’s going to work like the Microsoft Data Management that works ok.
        Install the Gateway in the server (I have a server with access to all the needed Databases). adm account? I’ll have to boy a Power Bi license to this adm Account? I’ll have to log in with this account into Power BI to deploy a new dashboard and schedule a refresh?

        Regards

        1. Hi Rodrigo.
          The user shouldn’t be necessarily an admin. As far as it has access to the database to read data you should be OK.
          Generally, if you want to refresh on-prem data from Power BI website you should pay for Power BI Pro. But, if you just want for testing purposes then you can apply for Power BI Pro Trial. You can find it here: https://support.powerbi.com/knowledgebase/articles/664495-free-trial-for-power-bi-pro
          To be able to successfully setup a schedule refresh, you need to login to Power BI website using a user account within the same domain.
          It’s not necessary to login with the same user as Personal gateway. But, as I mentioned the user should be in the same domain.
          So here is how it work:
          1- You setup your Power BI Personal gateway on a server. The user you use here has sufficient access rights to all databases you need.
          2- You login to the Power BI website with a user of a same domain OR you publish the predefined visualisations from Power BI Desktop with a user from the same domain.

          Therefore, if you install Power BI Personal Gateway using a user of domain X then you’ll be able to refresh data from Power BI website that you login with a user of domain X. If you login using a user of domain Y then you won’t be able to setup a schedule refresh.
          Hope it helps.
          Cheers

          1. Hello Soheil

            It works! One thing I didn’t noticed was that you have to be logged into powerbi.com while installing de Power Bi Gateway, otherwise you’ll receive “Gategay not reachable” as I was.
            many thanks!

            Regards

            Rodrigo

Leave a Reply