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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Dynamic longitude and latitude (moving item). Track moving location

Hi, How dynamic point to be view in map/globe/filled map in separate point but in one map? Because currently I'm having the longitude and latitude in SQL table with 3 different device. Example DeviceA, DeviceB and DeviceC. So, in Azure SQL I'm having Column DeviceID, Longitude, Latitude and Address(the current address from Lon & Lat) If I'm getting the data from SQL, the map will have 3 points but it have like 3 pie in every one point. How do it be a single point for every device? I need to show 3 individual points in a single map. And this point will be moving frequently. I see on forum, discussion, tutorial, example, most of them showing static location. I'm having a different situation here. It's like tracking the device location and show on dashboard.



You can also try with the new introduced feature ArcGIS Maps. Drag your four columns into fields as below. There will be three different color points in a single map.


Dynamic longitude and latitude (moving item). Track moving location_1.jpg


Best Regards,


Hi Herbert,


This maps look promising. But unfortunately, it require some $$ as for this POC things, nothing much we can do. So, I'm depending on what default and visual gallery have for my project.


But perhaps if you know some other way to view the last dataset (newest) as a single point, it will be much better. Data is sending real-time, so I need to locate it real-time (near is accepted by client) too



If there is a datatime column in your dataset, you can create a measure to define the last point size as the biggest in the whole map. The earlier address point size will be blank and not show in the map.


Dynamic longitude and latitude (moving item). Track moving location_1.jpgDynamic longitude and latitude (moving item). Track moving location_2.jpg


Best Regards,


Community Champion
Community Champion

@liey87 Using standard Map visual if I don't have any field on Legend section it will only show one point (bubble) per location.




But if I have Legend section filled than each point will be pie representing values from that field. And when doing refresh if data in your table changes it will update map accordingly. Hope that answers your question.





Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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