Data type conversion issue

[MeghnaZutshi]

I have a column with numeric,alpha numeric and text data in it and data type is "general". When i import it into power Bi, it is automatically converting the data type to text but then i change it to "any" data type. For alpha numeric and text , it is working fime but the numbers especialy the 15 digits numbers a, only first 7 digits are coming anfd rest digits are changed to 00000000.

Eg. this number 211007100009274 is getting changed to 211007100000000

i need the exact number here. 

Any solution for this. Thank you in advance

[Adamboer]

It seems like the number is being truncated due to the limitations of the data type you are using in Power BI. To avoid this issue, you can change the data type of the column to a data type that can handle large numbers, such as a Decimal Number or Whole Number data type. Alternatively, you can try formatting the column as Text before importing it into Power BI to prevent any automatic data type conversions. Once the data is imported, you can change the data type of the column to Decimal Number or Whole Number and the full number should be displayed.

[MeghnaZutshi]

hi @Adamboer 

Thanks for the response but i cant  change the data type of the column to Decimal Number or Whole Number  as my column has numeric,alpha numeric and text data.