Connect to PostgreSQL with Get & Transform in Excel 2016 (Npgsql)

Hello.
Yes and No.

Yes: It was recently solved by our IT Department, by them buying the license to have PowerBI Server through which you can also deploy reports as web links to users. At the Server Setup it worked to get it connected straight away.

No: Did never get it to run directly into the Postgres from a PowerBi Pptx file.

Work Arround that I used for a while:
I set up a FTP routine shedule in our reporting software that dumped the data that I needed on to a secured folder on the local drives, where I rolled out the PowerBi file in question. PowerBi has an organisational access validation integrated that enabled those that needed to read the source data in the secured folder. Still a bad & sad workaround in comparison to the server solution, but it works.