This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 43%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
I have an 18 digit number as a row identifier, it is unique to 18 digits. SSAS insists there are duplicates. This is because it converts "long" numbers to scientific notation, but when you request it as whole number only the first 15 digits are correct the last 3 are all zeroes (0). The last 3 digits in my identifier are what make it unique. Please fix this bug. There are numerous posts for Excel doing this, but SSAS does it as well. Same engine I'm guessing. Power View? This is frustrating.
So what data type to you use? I don't work with Analysis Services myself, but I look at https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/olap-physical/data-types-in-analysis-services?view=sql-analysis-services-2025, and the first data type listed is bigint, which is big enough to handle 18-digit numbers.