cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nickelcap Frequent Visitor
Frequent Visitor

Map Visualization Will Not Accept Latitude and Longitude

Hi Everyone,

 

I've set up a large volume of GPS latitude and longitude values that coincide with time stamps and an RPM value in a table, which I thought could be used in Power BI Desktop to create an interactive map.  However, when I try to make the visualization in Power BI Desktop I get the following: Report Pane. When I cursor over the yellow alert icon I get the message: "Location is required to create a map. Click to learn more." Which, when clicked through, does not provide much helpful information.

 

So far I realized that I needed to set the Long and Lat columns data categories to the correct type, so I've done that. I thought that maybe I had duplicate Long and Lat values so I brought the table back into Excel, removed duplicates from both columns (which really reduced the number of data points, unfortunately).

 

Any ideas? What am I doing wrong?

 

Thanks, 

 

Dan

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Map Visualization Will Not Accept Latitude and Longitude

Drag your timestamp field or create some sort of text field and drag it into Location


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Super User
Super User

Re: Map Visualization Will Not Accept Latitude and Longitude

Create a New Column => Location = [LATITUDE]&","&[LONGITUDE]

 

Then place Location column in the Location field and remove Lat and Long.

If you add a Legend you'll need Values too which you have.

 

That's how I get around this issue... Maybe there's another way too...

5 REPLIES 5
Super User
Super User

Re: Map Visualization Will Not Accept Latitude and Longitude

Drag your timestamp field or create some sort of text field and drag it into Location


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Super User
Super User

Re: Map Visualization Will Not Accept Latitude and Longitude

Create a New Column => Location = [LATITUDE]&","&[LONGITUDE]

 

Then place Location column in the Location field and remove Lat and Long.

If you add a Legend you'll need Values too which you have.

 

That's how I get around this issue... Maybe there's another way too...

nickelcap Frequent Visitor
Frequent Visitor

Re: Map Visualization Will Not Accept Latitude and Longitude

Worked like a charm, thanks. 

fitnesspowerbi Regular Visitor
Regular Visitor

Re: Map Visualization Will Not Accept Latitude and Longitude

As of today it appears that they have fixed the issue with latitude and longitude, you should be able to use them without having to make a calulcated column to concatenate them.

nairisha Regular Visitor
Regular Visitor

Re: Map Visualization Will Not Accept Latitude and Longitude

This solution worked for me. Thank you.