incorrect data show

[Anonymous]

Hi every one,

I have excel file with field name account No the value is  long  = 108095087890027

when I load file to power BI The format changed to hexadecimal = 1.08095E+14

my question: 

how I ca show original value  like excel file  after load data to power bi  ?

[TeigeGao · Accepted solution]

Hi @Anonymous ,

It looks like that the number is recognized as Scientific format when you import the Excel file to PowerBI Desktop, we can change the format to whole number.

Best Regards,

Teige

[AkhilAshok]

Have you tried formatting the column? Maybe make it a Whole number.