map
31 TopicsEdge device detections into Fabric: Eventstream + Eventhouse, or Lakehouse?
Hi all, While working on a computer vision project at DataToBiz, we built the edge side of a real-time system, and I’d like to compare notes with people here on how the data side would work in Fabric. On the edge, the detection runs on a Raspberry Pi. We used YOLOv8n with ByteTrack to track vehicles across frames, plus Depth-Anything-v2 for depth estimation from a single camera so we could apply spacing rules. The model was converted to ONNX, TFLite and NCNN, and we used quantization and threading to get the speed we needed without heavy hardware. A camera, GPS and compass were synced by timestamp, so every detection comes out tagged with its time, location and direction. Post-processing smooths the detections to reduce flickering. That leaves a stream of time-stamped, geo-tagged detection events from many devices, and that’s the part I’d like your input on in Fabric. Would you ingest it through Eventstreams into an Eventhouse and query it with KQL, or land it in a Lakehouse and process it in batches? Where does that line sit for you when the end goal is near real-time dashboards? How do you handle devices that go offline and send their events late or out of order? Do you rely on event time in the Eventhouse, or clean it up downstream? For the geo side, with coordinates and direction on every event, how have you handled spatial queries and map visuals in Real-Time Intelligence or Power BI? Is it good enough, or do you still end up pre-processing the coordinates? And with raw detections arriving continuously, how do you decide what to keep as raw events, and what to aggregate into something like per-location availability for reporting? Would love to hear how you’d approach it.19Views0likes0CommentsAzure Maps base layer not loading in Real-Time Dashboard - Only points visible
Hi Fabric Community, I'm experiencing an issue with Map visualizations in Real-Time Dashboards. The data points are rendering correctly, but the Azure Maps base layer (streets, terrain, satellite) is not loading - only a white/blank background appears. **Environment:** - Microsoft Fabric Real-Time Intelligence - Real-Time Dashboard with KQL queries - Eventhouse as data source - Browser: Chrome/Edge (tested both) - Region: South Central US **Steps to reproduce:** 1. Create a KQL query with latitude/longitude columns 2. Add to Real-Time Dashboard 3. Change visual type to "Map" 4. Configure: Latitude column, Longitude column, Label column 5. Points appear but no map background **What I see:** - Colored circles representing my 10 GPS devices - Correct relative positions between points - Zoom controls (+/-) present but don't show map tiles - "Center" button works for positioning **What I expected:** - Azure Maps base layer with streets/roads visible behind the points **Troubleshooting attempted:** - Tried different browsers (Chrome, Edge) - Cleared browser cache - Verified coordinates are correct (Mexico City area: 19.5, -99.3) - Checked browser console - no obvious errors **Questions:** 1. Is there a known issue with Azure Maps in Real-Time Dashboards? 2. Are there specific tenant/admin settings required for Azure Maps? 3. Is this a preview limitation? Screenshots attached showing points without map background. Thank you for any guidance!Solved4.2KViews0likes2CommentsArchitecture & GPS hardware
Hello Fabric community, I'm building a fleet monitoring platform for trucks/vehicles and need architectural guidance for using Microsoft Fabric Real-Time Intelligence, as well as GPS hardware recommendations. MY SCENARIO: ------------ - GPS trackers sending location data every 10-60 seconds via TCP - Data includes: GPS coordinates, speed, fuel level, engine RPM, temperature sensors, driver behavior (harsh braking, acceleration) - Need to support multiple tenants (each customer sees only their own fleet) - Planning to scale from 50 vehicles to 1000+ vehicles - Want real-time dashboards + historical analytics + automated alerts - Future: add video/dashcam capabilities MY PLANNED ARCHITECTURE: ------------------------ GPS Devices → TCP Server (Traccar/custom) → Azure Event Hub → Fabric Eventstream → Eventhouse → Real-Time Dashboard QUESTIONS: GPS Hardware: ------------- 1. What GPS tracker brands/models do you recommend that integrate well with custom backends and Microsoft Fabric? I'm considering Teltonika FMC920, Queclink, or Concox - any experience with these? 2. Which GPS devices have the best open protocols for parsing data and sending to Azure/Fabric? 3. Any recommendations for GPS trackers with OBD-II support to read vehicle diagnostics (fuel, RPM, error codes)? Microsoft Fabric Architecture: ------------------------------ 4. Is Eventstream + Eventhouse the right approach for high-frequency GPS telemetry data? 5. What's the recommended way to implement multi-tenancy (row-level security) for different fleet customers? 6. Should I use KQL Database or Lakehouse for storing historical GPS data (months/years)? 7. Any recommendations for handling geofencing alerts in real-time using Activator? 8. What Fabric SKU (F4, F8, F16?) would you recommend starting with for ~100 vehicles sending data every 30 seconds? I'm based in Mexico and planning to deploy this commercially for fleet owners. Any guidance from people who have built similar IoT/telematics solutions with Fabric would be greatly appreciated! Thanks in advance!Solved6.7KViews0likes4CommentsDeprecated of Map and Filled Map in Report Server
i amd currently working on Map and Filled Map in PBIRS, but i find that they will be deprecated someday. Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn there is a post talking about this and i don't think keeping old version of PBIRS is a good solution. Solved: Re: Power BI Server and Azure maps - Microsoft Fabric Community i know that service and report server are two different roadmaps, is there any clear roadmap for Map and Filled Map in PBIRS?Solved1.6KViews0likes3CommentsDirectQuery latitude and longitude for map
I'm working on a project where we have an MQTT GPS locator on our site. We want to display that locator's current location. We are sending the sensor's data to a Streaming Dataset. I can see and create a table with all of the updates (I have a timestamp and an "ID" where I'm evaluating the time in UNIX format to give a unique identifier). I want to show the current location, therefore the most recent snapshot. I keep getting stuck evaluating the last row due to DirectQuery restrictions. I finally got calculate(max...)) and lookupvalue to give me a single latitude and longitude, but when I put those into the Map visual I get "To display latitude and longitude pairs, set the aggregate for Latitude and Longitude to Don't summarize" which I can't do with a measure. I was worried Map was aggregating the values anyway (dispite there being only one value), but I can't make a measure that it will take as a Location. Feeling stuck on something seemingly simple!!!!Solved1.1KViews0likes5CommentsShape map in Power BI Desktop RS
Hello community, Last september, I created a report on PBI Desktop for Report Server which contained a shape map (with a TopoJSON file). But today, when I reopened it to do a modification, the component had disappeared from the visualizations pane. The visual is still present in the report, but it is not possible to add a new one (except by copy/paste the old visual). Is it normal that this component disappeared from the visualizations pane?3.6KViews0likes4CommentsLayer Order Issues with Map (Help)
I have created a custom map as part of my visual and am trying to overlay a shape with text on top of the map. I have selected maintain layer order for both the map and the shape as well as moving the map to the the back of the layer order and moving the shape to the front of the layer order but whenever the map is selected or a mouse hovers over the map, the shape with the text moves behind the map. Is there a clear fix to this issue? Everywhere I have looked has said to enable maintain layer order for both and move the map to the back and the shape to the front but this is not working for me. When the map is not selected or hovered over the shape stays in the front.Query re bar chart and map visual
I am trying to create two visual I saw on a site. The data I have is very similar in that I have regional information, and trying to find out if any one knows how this might have been created? I did research deneb and other tools on visuals, but if aanyone can help guid me to the best way that would be really appreciated. The bar chart - its to permenantly show the data label offset off the chart. I created a measure for the data lable etc, but not show how to show it in the style of the chart (please see the url for an interative demo) The atlas vistal, I have regional information, but the closest I got to was bubbles on the map. I really like the pin shapes with the data labels, I was wondering how they created that? https://www.ilo.org/DevelopmentCooperationDashboard/#av344tb Any direction on the best tools to use from your experience would be really helpful ThanksUse custom visual MapBox offline
How can I add and use a map to a Mapbox visual for a Power BI report that is in reportserver that's offline. I have found maps in Json that can work. I'm also open for solutions with other custom visuals using images if that can result in a detailed map. I'm also interested in using ArcGis offline if anyone has a way of doing that too!1KViews1like1CommentCombining Multiple Measures into a Unified Pie Chart Overlay on Power BI Map
Hello Power BI community! I have measures for sales, gains, and losses. I aim to display their aggregate in a pie chart overlay on a map (power bi default map - not Azure Map), segmented by measure type. I have the location set on town name and it works fine but I just need the measure to show in one bubble. Essentially, the measures would be in the legend and the value. For instance, a town might display 25M in sales, 21M in gains, and 12M in losses. While I can visualize each measure independently on the map and segment with a dimension column in the legend, I need a unified view for all three measures that is segmented by the measure type. How can I achieve this with the measure as the dimension in Power BI? I believe I am looking for a calculated table with a switch statement, but I am not sure.1KViews0likes1Comment