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
You need to install a Personal Gateway (you can try to do that on the NAS server too but it is HIGHLY discouraged to have the gateway share resources with other apps). You also need to manually copy the npgsql ADO drivers from Desktop to gateway, as there is currently a bug (installer files missing).
Could you please explain in detail :"You also need to manually copy the npgsql ADO drivers from Desktop to gateway..."? I get the message in powerbi service all the time: Install Npgsql product version 4.0.10.0 or earlier.
- 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