I don't understand why when we made the join the type of duedate became string while the type of the foreign key Date of the table dimdate stayed integer. in addition, if we go in the transform field we find that the type of duedate is still date/time.

This is a Power BI behavior, basically it is converting the foreign key to a different data type, I believe this is to do with the fact that Power BI does not like to make relationships based on dates so it is changing the data type and in the background is recognizing the column as string.

Follow this topic

OMAR OUAISSI_SEKOUTI

Last answered:

15 Dec 2021

Posted on:

15 Dec 2021

"duedate" type become string

in Power BI / Hierarchies

1 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

15 Dec 2021

"duedate" type become string

Submit an answer

related questions