cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mohammed Member
Member

incorrect data show

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  ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
TeigeGao Senior Member
Senior Member

Re: incorrect data show

Hi @mohammed ,

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.

gTyjdgkl5N.gif

Best Regards,

Teige

2 REPLIES 2
AkhilAshok Established Member
Established Member

Re: incorrect data show

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

TeigeGao Senior Member
Senior Member

Re: incorrect data show

Hi @mohammed ,

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.

gTyjdgkl5N.gif

Best Regards,

Teige