Forum Discussion

Gazzer's avatar
Gazzer
Resolver II
8 years ago

Whole Number ID Problem (19 Digits)

My data source is using 19 digit integers for unique IDs. According to specification, this is fine with Power BI (19 digits being the maximum width).     When I merge one query with another using ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have the same issue.

 

Importing data from an Oracle DB with rows of ID's with 19 digits and no signs (as a primary key).

 

Figured out several issues when  formating it to a "Whole Nr." (Int.Type 64).

  • Column Sorting in retrieving -> receiving even more, or less items
  • Relationsships in data model -> cardinality
  • Merging tables

 

After formating to "Type TExt" it works.

 

Whats wrong? In my understanding computing digits (instead) of text is even more "easy" for a computer...

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have the same issue. When reading in a data table from CSV, the unique 17-digit ID column (no signs) gets converted to a WholeNumber type. These numbers are no longer unique and dropping duplicate rows based on this column reduces the size of the table by half. When converting the ID column back to text, every row has a unique ID again and no duplicates are detected. Why?