We have a PostgreSQL database on a Linux server. I can easily connect to it with the required credentials from PBI Desktop but naturally(?) not able to perform live connection.
My client doesn't allow me to install a gateway on a virtual machine for some reasons.
Dataset on the published report returns me this error message: "Your data source can't be refreshed because the credentials are invalid."
As I know, there is no way to create a live connection and scheduled refreshes from an on-premises PostgreSQL db without a gateway.
Do you have any alternative brilliant idea to get a solution on this case without using a gateway?
ps-1: Our dataset is quite tiny so they can replace it from PostgreSQL to anywhere, even to Excel files.
ps-2: I've tried both (ODBC drivers and PBI's direct PostgreSQL connection)
Thanks a lot.