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
cute. Set your gateway to allow refresh of cloud data sources.
Well, I don't see any way to include it.😔 Is it possible that the problem is the personal version of the gateway?
Potentially. You can try to use the enterprise version.
Thanks for all the answers but unfortunately I still can't assign a gateway to this connection 😞 Maybe you could recommend some step by step tutorial on how to connect local postgres database with powerbi service?
As you may have noticed you are on the bleeding edge of this. My experience is limited to an enterprise environment where it works reasonably well. Can't test your setup, sorry.