Today I have updated the server to 4.6.1 version (from 4.5.3) and tested again PowerBI connection. Now it connects correctly using PostgreSQL datasource using DirectQuery with non privileged user.
But the problem now are the timestamps: All show as “Error”, autogenerated ones and inserted ones, see Problem with PowerBI Desktop and Timestamps - #2 by iames.