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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
liey87
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.
4 REPLIES 4
v-haibl-msft
Microsoft Employee
Microsoft Employee

@liey87

 

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,

Herbert

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

@liey87

 

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,

Herbert

ankitpatira
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.

 

Capture.JPG

 

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.

 

Capture2.JPG

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.