Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to Solution.
Hi @Anonymous ,
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.
Best Regards,
Teige
Hi @Anonymous ,
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.
Best Regards,
Teige
Have you tried formatting the column? Maybe make it a Whole number.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |