I have 17 digit integer IDs from an OData source. I have tried converting the type to string but when I try to show the IDs as rows, Tableau aggregates all values within 8 places of each other (same problem while blending). This is demonstrated in the image, the actual data has sequential values. The number on the right is the count of records.
When using the same OData source in Excel I can get around the problem by converting the ID field to a string.
I haven't been able to find anything on the forum like this, does anyone have any ideas?