Forum Discussion

GerryFlanagan's avatar
GerryFlanagan
Microsoft Employee
10 years ago
Solved

Installing Personal Gateway on a SQL Server

Hi,   I've been using Power BI desktop for a while and the all the reports I've published refresh fine through the personal gateway on my local drive. The problem is I dont want my local drive to a...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    You can install the Personal Gateway on any domain connected PC so that should not be a problem at all. Note that you could install the Personal Gateway on any VM or PC you wanted, you do not have to install it on the SQL Server itself just because that is where the data lives. As long as your VM or PC can communicate with the SQL Server properly, it can retrieve the data.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

You can install the Personal Gateway on any domain connected PC so that should not be a problem at all. Note that you could install the Personal Gateway on any VM or PC you wanted, you do not have to install it on the SQL Server itself just because that is where the data lives. As long as your VM or PC can communicate with the SQL Server properly, it can retrieve the data.

Mond's avatar
Mond
Helper III
9 years ago

Greg_Deckler ,

 

Why can't we use Enterprise Gateway created on the VM/PC where Power BI is installed.

 

What is the advantage of using Personal Gateway over Enterprise and which credentials are stored on the Personal Gateway.

 

If personal gateway is connected with user credentials to particular sql server, the user might go out of company and underlying reports/dashboards will fail.

correct me if I am wrong.