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 automaticall...
Need Help
  • qwert101's avatar
    qwert101
    6 years ago

    Thank you, that seemed to work.

     

    Kind Regards.

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.

  • qwert101's avatar
    qwert101
    New Member
    6 years ago

    Thank you, that seemed to work.

     

    Kind Regards.