Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

Can't get coordinates correctly on map

Hi all,


I have a large dataset with BLE beacons (TagText) and per beacon the historic location (LAT, LON) and the time seen at that location.
I want to have a visual where I can see how the beacon travelled and another map which would be the heatmap of all beacons at their last seen location.

I imported the data and have a dataset as follows:


I assign the LAT & LON field to their correct data category




Than I just drop the LAT & LON in the corresponding visual fields.
Than I get a map with three points and when I hover over it, the tooltip gives me 358 different coordinates. 




I would expect all these points to be separate. I choose to not sum the data




When I add the datetime field to the TIME Field on the visual, I get a timebar but it doesn't show correct points either.


Another thing I tried, was the normal map visual. But when I add LAT & LON, nothing seems to happen on the visual.

Help is needed 🙂


Thx in advance for all tips & tricks.

Super User
Super User

@TomBelgium Perhaps add an index column or use the time field in the Legend?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I just played around a bit and finally managed to do both somehow. 

Apparently the field was set as text. After changing it to decimal, it seems to work.



So, I can start playing around! 


Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.