cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisH Regular Visitor
Regular Visitor

Converting Longitude to Decimal data type

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Converting Longitude to Decimal data type

Hey,

 

check the "Regional Settings" of the current Power BI file:

image.png

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

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Converting Longitude to Decimal data type

Hi @ChrisH ,

By my tests, I cannot reproduce your issue.

Capture.PNG

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChrisH Regular Visitor
Regular Visitor

Re: Converting Longitude to Decimal data type

Hi 

 

Got this sorted by changing regional settings in PB for decimals

Super User
Super User

Re: Converting Longitude to Decimal data type

Hey,

 

check the "Regional Settings" of the current Power BI file:

image.png

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

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 43 members 1,068 guests
Please welcome our newest community members: