Problem with PowerBI Desktop and timestamps

Integrations
2

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, the all show as “Error”, autogenerated ones and inserted ones.

This problem happens with all timestamp columns on all tables, for example I have a table definition like this:

CREATE TABLE IF NOT EXISTS "south_mill"."processed_data" (
   "var_id" BIGINT,
   "var_date" TIMESTAMP WITHOUT TIME ZONE,
   "var_value" DOUBLE PRECISION,
   "var_creation_date" TIMESTAMP WITHOUT TIME ZONE GENERATED ALWAYS AS _cast(current_timestamp, 'timestamp without time zone'),
   "var_year" INTEGER GENERATED ALWAYS AS EXTRACT(YEAR FROM "var_date"),
   PRIMARY KEY ("var_id", "var_date", "var_year")
)
CLUSTERED INTO 4 SHARDS
PARTITIONED BY ("var_year")

Column var_date is inserted and column var_creation_date is automatically created on insertion. On PowerBI the result is

image
image868×412 13.5 KB

On a more simpler table (is not partitioned or part of the key) the error is different

image
image1264×334 13.3 KB

Any ideas of what is happening? When I initially posted this topic I tried a nightly 4.6.0 build of Crate and I don’t remember this problem.