Problem in Power BI desktop with dimensinal tables

[dual05]

Hello,

We have imported in Power BI two tables, a table of facts and another of dimensions, from our PostgreSQL database using the following conector: Npgsql-3.2.4.msi. (below, an image with both Facts and Dimensional tables stucture)

The relations between them, by joining common fields, can be defined without any problem. (image below)

However, the fields corresponding to the dimensional table which were used in the definition of those relations show different values in Power BI from those which they show in PostgreSQL. (images below: values shown in Power bi vs values shown in PostgreSQL)

 

This only occurs in the dimensional table, the facts one behaves correctly. (image below)

We've tried to modify the Keys definition in the dimensional table by changing the instruction 'pk(int), text' to'text, pk(int)', but the problem still existis.

Anyone who had a similar problem in the past and managed to solve it or just knows exactly what can be happening will be extremely helpfull for us.

Thank you!

[Anonymous]

Hi @dual05,

I'm not so sure how did your issue appears, can you please share a pbix file with sample files?

Regards,

Xiaoxin Sheng

[dual05]

@Anonymous

Hi Xiaoxin Sheng,

Thanks for your interest,

The problem seems to be related to Power BI PostgreSQL connector, because there is no problem if we first export these data from Postgre to Excel/CSV and then import them to Power BI, and neither if we directly connect Power BI to SQL Server.

Regards.

[Anonymous]

HI @dual05,

I think you can also submit a support ticket to report these compatibility issues.

Regards,

Xiaoxin Sheng