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.
I have a power bi file that pulls data from our database. One of the fields is "Location". When the location is something like 11E4 and I export this into excel, it creates a scientific notation. How do I prevent this from happening?
Solved! Go to Solution.
There might be more than 1 thing you need to try to get this corrected. Excel has settings for both auto formatting and data "cleansing". These can be disabled if you hunt through the options.
Which one you need to do will depend on whether excel is changing the data itself, or simply changing how its displaying the data.
There might be more than 1 thing you need to try to get this corrected. Excel has settings for both auto formatting and data "cleansing". These can be disabled if you hunt through the options.
Which one you need to do will depend on whether excel is changing the data itself, or simply changing how its displaying the data.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |