Issue when deploying hybrid tables to PBI Service with PostgreSQL

[EdgarsSF]

We have built a dataset that takes data from PostgreSQL database (using Get Data from PostgreSQL database) and implemented hybrid table setup for one of the fact tables. This is how the model looks like. Dim - Date is in Dual mode and Fact - Time spent is in Import mode.

And this is the incremental refresh policy:

And this is what we see in PBI Desktop for the visualizations:

When publishing this dataset to PBI Service and performing initial dataset refresh, this is what we see for that report (error from card visualization):

And this is the other error message (from error above in red):

When nothing is selected in the slicer, data appears in the card visualization:

This is the PostgreSQL version that we are using: PostgreSQL 15.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-15), 64-bit

We have tested this with MSSQL and with that approach everything works fine - no error messages. 

[v-yetao1-msft]

Hi @EdgarsSF 

When you select any item on the slicer, does it report an error?

Best Regards,
Community Support Team _ Ailsa Tao

[EdgarsSF]

Hi @v-yetao1-msft 

There are no errors when nothing is selected:

But when something is selected, there are errors, and this is the following one for that card visualization: