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.

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.