# Problem with PowerBI Desktop and timestamps

**URL:** https://community.cratedb.com/t/problem-with-powerbi-desktop-and-timestamps/753
**Category:** Integrations
**Created:** [July 27, 2021, 12:56pm UTC](https://community.cratedb.com/t/problem-with-powerbi-desktop-and-timestamps/753 "2021-07-27T12:56:15Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![iames](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@iames](https://community.cratedb.com/u/iames)
#### Post date: [July 27, 2021, 12:27pm UTC](https://community.cratedb.com/t/problem-with-powerbi-desktop-and-timestamps/753/2 "2021-07-27T12:27:11Z")

</div>

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:

```auto
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](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/d52bfabfec1190abf291f1b6e6baa17ec2df1a36.png)

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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/96470661e6fefdc571b1fe76f79d43d5a0a2b5ab.png)

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.

---

_[View the full topic](https://community.cratedb.com/t/problem-with-powerbi-desktop-and-timestamps/753)._