Forum Discussion

qwert101's avatar
qwert101
New Member
6 years ago
Solved

Number From Excel Automatically getting rounded in PowerBI

Hi,

 

So I'm importing in a school data sheet into Power BI from excel.  My student id is a 14 digit number (i.e 12500300981613) and a unique id.

 

When I import it into Power BI, it automatically transfers into 12500300981000.  In the Query Editor it is: 

1.25003E+13

 

I've tried all ways to make sure the number stays the same...This is happening only one file...the rest are ok.

 

Any help would be appreciated.  Thanks.

 

Need Help
  • qwert101's avatar
    qwert101
    6 years ago

    Thank you, that seemed to work.

     

    Kind Regards.

4 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

    qwert101,

     

    Have you tried to change the data type to text instead of number on your excel file?

    • qwert101's avatar
      qwert101
      New Member
      6 years ago

      Hi,

       

      So that seems to work, but it is a saved as a number on ther other tables, so the join is not working.  

       

      Would I have to change all of them to text to make it work?  Or is there a work around...

       

      Thanks.

      • mussaenda's avatar
        mussaenda
        Community Champion
        6 years ago

        qwert101,

         

        If it is saved as number on other tables, you can duplicate the column and set that duplicated column to text. It is like 2 same columns but 2 different data types.