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
Thank you for your reply, I will check. Do you perhaps know if a DDNS based solution should also work?
Can't see why that would be relevant. Communication is outgoing, from the gateway cluster members to the Azure cloud. Not the other way round.
Forgive me but I'm not familiar with network connections. All I'm trying to do is connect powerbi online to the database on my servers without any external services. No fixed public IP is not a problem?