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
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