Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am loading Excel data into Power BI. This data has ID columns which have large numbers. Excel converts these to scientific notation by default. I can convert them into regular numbers by formatting them as number columns. But then when I load then into Power BI, they get loaded in scientific notation. When I try to convert the numbers into text, like they should be, they go back into scientific notation. Is there a way around this?
Hi aabi01,
You may try function below in power query and check if the column value can be changed to text format.
=Number.ToText(Number.From())
Regards,
Jimmy Tao
I just experimented with this. I left the numbers in scientific notation in Excel. I imported into Power BI. Power BI displayed them in scientific notation but the underlying data was their actual numbers. Converting to text displayed them as their full number values.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |