A challenge with the current Power Query PostgreSQL data connector is that it does not understand how to work with PostgreSQL’s complex typed columns. Background Scenario: PostgreSQL allows a ...
Postgres simple arrays match easily to M lists, this feels like the expected behaviour. It's not even consistent. The arrays are only converted to text with a direct navigation. If a custom SQL query is used, the array columns are loaded as errors.
