Forum Discussion
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 ...
Hi there,
it is May 2024 and I'm face same problem here. There is id field in database, containing 19 digits ids with the "-" sign in front of them. (exampl [-1234567891234567891].
When query is loaded in Power Qeury I see all numbers as it should be. When data is loaded into the report, in Table view I see number as it should be. But:
- when I try to join tables on this field, I getting warning that it will be many-to-many join. This should not be, as one table has only unique id, and the other one is having list of events related to particular id
- when I put this field in the table visual, I see Power Bi converts last 3 digits to zeros