map
3 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.17Views0likes0CommentsAzure 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.7KViews0likes4Comments