Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |