general comment
12 TopicsArchitecture & 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.7KViews0likes4CommentsRTI Event Metadata Table Use Cases
Hi everyone, I’m looking to expand how others are using metadata tables in Microsoft Fabric RTI architectures. Current state We have an IaC-driven deployment process that provisions RTI assets from source → bronze → silver. As part of this deployment, we persist configuration and lineage information into a metadata table stored in SQL DB. At a high level, the metadata schema includes: EventTopic SourceObjectSettings (JSON) – bronze/silver table names, flatten function, etc. TopicInformation (JSON) – topic-level semantics Audit columns (create/modify user + timestamps) The metadata is written at deploy time and represents the intended RTI topology. Current primary use case: Bronze → Silver reprocessing Our main use case today is controlled reprocessing from bronze to silver. Since Fabric update policies only apply to data in motion, when we need to: fix a flattening bug handle schema changes correct downstream logic we need a way to deterministically replay historical data. To support this, I built a parameterized pipeline that accepts: EventTopic StartTime EndTime The pipeline triggers a fully parameterized notebook that: Uses the provided EventTopic to query the metadata table Retrieves the associated flatten function, bronze table, and silver table Dynamically builds the KQL query Reprocesses bronze data for the specified time window into silver This approach avoids hard-coded topic logic and has worked well so far. What I’m looking for I’m interested in learning how others are extending this metadata-driven pattern beyond reprocessing, particularly in larger RTI platforms. What other valuable use cases have you found for metadata tables in RTI architectures? Any lessons learned or pitfalls would also be appreciated. Thanks in advance.Solved7.1KViews2likes4CommentsMicrosoft Fabric Known Issues
Known issues are temporary bugs that we've discovered in Microsoft Fabric. These bugs are known and are being actively fixed. Before you submit a Support request, or search Community forums for an answer, see if the problem that you're experiencing is already known to Microsoft. There are two locations to look up current known issues: Known issues as a list on Learn Known issues as an interactive embedded Power BI report For service level outages or degradation notifications, check https://support.fabric.microsoft.com/. To create a support ticket, visit https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket.6.6KViews2likes0CommentsFailed to Create Trigger Reflex for Fabric Pipeline
I want my Fabric Data Factory to get triggered when a csv file is placed in Azure blob storage. I tried creating a trigger where I connected the Azure storage account. When I give name to my Reflex and click create, instead of successfully creating Trigger Reflex, it fails by giving the following error. Request failed with 404 (Not Found): {"error":{"code":"PowerBIFeatureDisabled","pbi.error":{"code":"PowerBIFeatureDisabled","parameters":{},"details":[],"exceptionCulprit":1}}} Error message: There was an error in alert creation. Please try again later. How to resolve this.Solved2.7KViews0likes1CommentData Activator Power BI Report Alert Refresh Rate
Hello, I have a Power BI Report setup with a table that reads from an Azure SQL table which gets refreshed in real time from a Synapse pipeline run with logging data. I have an alert set to listen when New Data Arrives, which should be only a handle of rows at a time. But currently there are two issues or limitations which I wanted to clarify. 1. The Reflex is triggering for every row of data in the table within the report every single hour, instead of it triggering for only the new rows. How can I set up the data to only trigger for the new data, or is there an issue here being that we're in preview? 2. The refresh rate for Data Activator reading data from Power BI Reports is defaulted to 1hour? Is there anywhere I can get this closer to real time or making any changes. I know that when this was first introduced last year the option to select refresh rate was there however it isn't anymore? Ideally I want a way for the Data Activator reflex to trigger in real time as soon as the Power BI report gets refreshed and there's new data there.Solved8.5KViews0likes5CommentsAdding a PowerBI Report Link to Teams/Email Message
Is it possible to add an option to include a link to the powerbi reports the events are being sourced from in the Act/Alert area? I'm trying to set up logic where a trigger occurs when employee turnover meets a certain threshold, and then provide a link to the powerbi report so the leader can see a table of the most recent employee exits. Right now, the trigger Teams/Email message would send user just to the reflex.2.1KViews0likes3CommentsEvent Stream Data to OneLake
As reflexes are taking periodic snapshots of powerbi data, we're seeing a use case where we could add properties and measures to a certain level of granularity and change that into a trending table. For example, historical snapshots of sales pipeline or forecasted revenue per day by 1-2 property categories (i.e. Region). it looks like the data is cached inside the reflex, was wondering if we could extract it for additional powerbi views. could be a lightweight way to create trending views.1.8KViews0likes2CommentsWe will be deleting old Power BI triggers on Friday 15 Sep
Hello all, Please note that this Friday, 15 September, we will be deleting Data Activator triggers created from Power BI before July 2. If you have Power BI triggers that you created before July 2 that you are still using, then you will need to recreate them. We apologise for any inconvenience. This step is necessary to allow us to release a particular bug fix. The deletion will delete the triggers plus their associated event streams. It will leave intact any reflex items and objects associated with the triggers.1.8KViews0likes0Comments