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.