Forum Discussion

mudegowdrp's avatar
mudegowdrp
Helper II
8 years ago

virtual machine data gateway setup

Hi,

 

I have Power BI dashboards which are built from various data sources  like SQL Server Database and some excel files from Shared folder(shared across the organization) but when my computer is on sleep mode, schedule refresh doesn't work. So I have VM but dont know how to connect and what data gateway to use.

 

1. Which data gateway I need to install on VM ( on premisis or Personal mode) ?

2. After installation how to use/change that(installed on VM) gateway in Power BI. Currently I have Personal mode gateway on my machine

3. Will it have WindowsImpersonation error/do I need to refresh manually.

 

Please help.

 

Thanks

 

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    To my Understanding,

     

    It is always recommanded to use Enterprise Gateway in an Organisation. 

    You can use your Recovery Key to migrate the Gateway from your PC to VM but I am not sure that recovery is going to work for Enterprise gateway(installed in VM) as the key is from Persoanl gateway.

    • mudegowdrp's avatar
      mudegowdrp
      Helper II

      Anonymous Thank you for responding. Is there anyway that I can know what my recovery key on my PC? I think I forgot that

      • Anonymous's avatar
        Anonymous
        Not applicable

        As far as I know, we can't find if you havn't kept the Recovery key before.

  • Hi, how did you proceed? Did it work? Looking for the same solution!

    • Anonymous's avatar
      Anonymous
      Not applicable

      I think there is no way to recover the Gateway recovery key unless you note it down somewhere.