eventhouse
45 Topics
Anomaly Detector is disabled
Hello, I have a big Table in which we have our TimeSeries data from various devices. Since not every device sends the same data we have a big schema of numeric columns that are not filled for every deviceId. Is that the reason why there is no Anomaly Detector in my EventHouse? In the schema I can see that columns for the data are int or real. Some columns are string, but that shoudn't be the reason, right? Has anyone faced the same issue?38Views0likes4CommentsEventhouse Capacity Planner minimum CU not reflected in UI/API
Hi all, We've set a minimum of 32 CU on our Eventhouse via Capacity Planner (autoscale alone isn't sufficient - we need guaranteed baseline capacity to protect a large bulk-ingestion workload from destination-side OutOfMemory during a migration). We've been told the 32 CU setting has been applied on the backend, but the Fabric UI and REST API (.show cluster / .show diagnostics) still report capacity/behavior consistent with a much lower tier. Can anyone confirm: Whether the a custom minimum CU value is actually enforced server-side even though the UI/API don't show it, and When UI/API reporting is expected to catch up to reflect the configured minimum? Any insight or similar experience would be appreciated.Solved117Views0likes6Comments
Fabric Eventhouse: Capacity policy for .ingest inline is hard-capped at 1 concurrent operation
Problem When using the KQL Activity in Fabric Data Pipelines to execute .ingest inline commands against an Eventhouse KQL database, the effective ingestion capacity is always 1 concurrent operation — regardless of the Fabric capacity SKU (tested on F2 and F8) and regardless of the cluster capacity policy setting. Running .alter-merge cluster policy capacity with ClusterMaximumConcurrentOperations: 16 succeeds without error, but .show capacity still reports an effective ingestion capacity of 1. Any pipeline pattern that executes .ingest inline within a parallel ForEach immediately hits 429 TooManyRequests / ControlCommandThrottledException errors. Highlighting that the capacity is 1. This makes the KQL Activity (KustoQueryLanguage type) unusable for parallel ingestion scenarios — which is an important use case in data pipelines (logging, event emission, watermark updates during parallel table processing). Question / Request Do you recognize this issue? if so I have the below request: Increase the effective ingestion capacity for Fabric Eventhouse to match what the capacity policy allows (respect ClusterMaximumConcurrentOperations)Solved478Views0likes11Comments
Copilot for EventHouse Queryset
Hi, RTI has introduced the preview feature of Copilot for the Eventhouse Queryset, but is there any way to automate the Copilot usage, via API endpoint or SDKs? The idea is to programmatically generate relevant and meaningful Kusto queries for business insights, from the tables and datasets present in the KQL DB in Eventhouse using Copilot. Thanks in advance!6.7KViews1like7Comments
Delay in Onelake Shortcut from Eventhouse to Lakehouse
I have a table in a KQL Database in an eventhouse that is hooked up to an Azure Eventhub. I have turned on One Lake storage for this table and added a shortcut to the lakehouse for this table. The table receives around 10-15k events per day and I have set the retention policy for the table to 30 days. The eventhouse table data was updating and getting reflected in the shortcut table within a few minutes when I first set it up. But now it takes almost an hour or more to see the latest event data in the shortcut table in my lakehouse. I turned the one lake availability off and then on again, and also tried updating the table policies but nothing seems to workSolved271Views1like4Comments
BCDR support for Fabric Eventhouse (KQL DB) – cross-region data replication and failover
Hi team, A few quick questions regarding BCDR options for Fabric Eventhouse (KQL): Does Fabric Eventhouse provide built-in cross-region redundancy/failover in case of regional outages? If yes, what is required to implement this, and what does the cost model look like? Does Fabric support native data replication/ copy capabilities? Specifically, is there support (or a roadmap) for: Azure Data Explorer (ADX/Kusto) → Fabric Eventhouse (KQL DB) Fabric Eventhouse (KQL DB) → Fabric Eventhouse (KQL DB) across regions (e.g., westcentralus ↔ westus) Could you please share any relevant documentation, known limitations, or guidance for these scenarios? Thanks in advance for your help!Solved1.4KViews2likes3Comments
Is there a way to deactivate an Eventhouse/KQL DB?
Greetings, all. I have eventhouses and KQL DBs in Dev and Test workspaces that are part of a deployment pipeline. They generate capacity usage even though no data is flowing in and no one uses them. I want to deactivate or turn off the Dev/Test objects until we want to use them for code changes for deployments so Prod isn't broken. Is there a way to do this?Solved9.8KViews0likes4CommentsReal-Time Intelligence: Unable to Connect KQL Database to Blob Storage
Hi everyone, I have a simple CSV file stored in Azure Blob Storage. I'm trying to read this data from my KQL database. I created the table by using the "Get Data" option in the EventHouse ribbon. Unfortunately, I am unable to connect to the storage account. There are no firewall rules or VNet restrictions in place, yet I’m receiving the following error: Error - Invalid URL. Either the URL leads to a blob instead of a container, or the permissions are incorrect. If you just granted permission, please wait a couple minutes and try again. Url - https://fabconnector.blob.core.windows.net/data container name is "data" I am following this MS wiki for guidence - https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-azure-storageSolved8.4KViews0likes9CommentsRestricted View Policy Bug
I am doing a direct ingestion from event hub to event house. When I apply restricted view policy on the table that is used for ingestion, the ingestion stops. That completely makes sense. But even though I give them the unrestrictedviewer access and database admin, still the records are not being ingested, which is wierd. Has anyone faced with this situation and do you have some suggestions or alternatives that I can leverage?Solved11KViews0likes16CommentsPrivate Endpoint support for direct EventHub → EventHouse connection
Hi everyone, we are working on a project where we ingest data from EventHub into EventHouse in Microsoft Fabric. Our EventHub messages are GZIP-compressed, so we currently use a direct connection from EventHub to EventHouse to store and process the raw messages (since, as far as I know, EventStream does not support reading compressed messages). At the ingestion stage, we only need to flatten the incoming messages — we don’t need advanced transformations or enrichment, which is why (despite of not supported gziped source) EventStream was not our first choice for this pipeline. Now we have a new security requirement: we need to secure our EventHub using a Private Endpoint. According to the documentation, Private Endpoint is not yet supported for direct EventHub → EventHouse connections, but it is supported when using EventStream as an intermediary. This raises a few questions: Is there an ETA or roadmap for enabling Private Endpoint support for direct EventHub → EventHouse ingestion? Would using EventStream as an intermediary be a viable solution for our scenario? Our data volume is a few dozen messages per second across five EventHubs — would EventStream handle this without performance issues? If yes, are there plans to support GZIP-compressed messages in EventStream? (The lack of GZIP support currently blocks us from using it.) Any recommendations, workarounds, or confirmation from the product team would be very helpful for us to plan our architecture. Thanks in advance!Solved4.7KViews0likes6Comments
