I’ve had an interesting project tossed into my lap. The client I am working for has a developed a web app that uses a PostgreSQL database proxied behind an NGINX web front end. The db is not publicaly exposed. We need to be able to -
Access the database for import queries into PBI using PBI Desktop
Have the data refreshed to the PBI server (probablly using the on prem gateway)
Most of my experience is with databases I have direct access too and can configure the on-prem gateway to refresh PBI Service.
Thoughts or Best Practice?