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 there
I am importing some longitude and latitude values from a text file.
I need to store these as numbers.
So my one longitude value is -2.511761
When I try to convert it to a decimal it gives an error saying it can't convert. Any idea why?
Many thanks
Regards
Chris
Solved! Go to Solution.
Hey,
check the "Regional Settings" of the current Power BI file:
It's likely, that your seetings do not match the character that is used in your text file.
Hopefully this provides some additional insights.
Regards,
Tom
Hey,
check the "Regional Settings" of the current Power BI file:
It's likely, that your seetings do not match the character that is used in your text file.
Hopefully this provides some additional insights.
Regards,
Tom
Hi @Anonymous ,
By my tests, I cannot reproduce your issue.
Please check if all of the values for longitude is like -2.511761.
If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
Hi
Got this sorted by changing regional settings in PB for decimals
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |