Forum Discussion

__Johan__'s avatar
__Johan__
New Member
5 years ago
Solved

Power BI automatically round 17 digit number causing erroneous joins

Hello,   I'm new to PowerBI so maybe I'm missing simething obviouos but I'm getting a really strange behaviour.   I extract data from the source system using dataflow. Each table has a unique 17 ...
  • mahoneypat's avatar
    5 years ago

    Storing a column as text over integer can have an impact but it shouldn't be significant unless you have millions of rows.  I would try out the easy fix as a text column and see the impact on file size and if there is any impact on performance (I expect not).  If not an issue, finish your model and make some reports.

     

    Regards,

    Pat