Forum Discussion
Connect postgresql database on the private NAS server and the powerbi
Mostly correct. The "on server" part needs qualification. You can install the gateway on any on-prem machine but usually it is installed on a dedicated VM in the on-prem cloud.
local = on-prem
- install Power BI Desktop (can be on your PC)
- go to C:\Program Files\Microsoft Power BI Desktop\bin\ADO.NET Providers
- grab the Npgsql.config file and the Npgsql folder
- on the machine where you installed the gateway go to C:\Program Files\On-premises data gateway\m\ADO.NET Providers
- paste the file and folder there
- restart the gateway service
I will ask the question in a different way. Is it possible to connect powerbi service to local postgre database only by using gateway installed on server?
Mostly correct. The "on server" part needs qualification. You can install the gateway on any on-prem machine but usually it is installed on a dedicated VM in the on-prem cloud.
local = on-prem
I did everything from the very beginning according to your instructions. I connected powerbi desktop to local postgre database 192.168.0.127:5678, loaded the data, saved and published.It says I don't need a gateway because the database is in the cloud and not locally. Any ideas on how to change this?