<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>Eventhouse and KQL topics</title>
    <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/bd-p/da_eventhousekql</link>
    <description>Eventhouse and KQL topics</description>
    <pubDate>Sat, 21 Nov 2026 20:16:38 GMT</pubDate>
    <dc:creator>da_eventhousekql</dc:creator>
    <dc:date>2026-11-21T20:16:38Z</dc:date>
    <item>
      <title>Latest value per device in KQL: arg_max, materialized view or a state table?</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Latest-value-per-device-in-KQL-arg-max-materialized-view-or-a/m-p/5421038#M676</link>
      <description>&lt;P&gt;I need the latest reading per DeviceId from a large table, and arg_max(Timestamp, *) by DeviceId takes several seconds on a big dataset. A materialized view using arg_max is much faster, but I am not sure about its ongoing cost. The other option I considered is a separate latest-state table maintained by an update policy. Which approach do you use for latest value per key, and have you run into problems with either one?&lt;/P&gt;</description>
      <pubDate>Mon, 16 Nov 2026 07:16:41 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Latest-value-per-device-in-KQL-arg-max-materialized-view-or-a/m-p/5421038#M676</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-16T07:16:41Z</dc:date>
    </item>
    <item>
      <title>Eventhouse: update policy or materialized view for aggregates?</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-update-policy-or-materialized-view-for-aggregates/m-p/5414353#M673</link>
      <description>&lt;P&gt;I tried two ways to get per-minute aggregates from a raw events table in an Eventhouse: an update policy that writes summarized rows into a second table at ingestion, and a materialized view using summarize by bin(Timestamp, 1m). Both feed the dashboard fine, but late-arriving events and backfills seem to behave differently. Which one do you use, and why?&lt;/P&gt;</description>
      <pubDate>Fri, 13 Nov 2026 00:51:35 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-update-policy-or-materialized-view-for-aggregates/m-p/5414353#M673</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-13T00:51:35Z</dc:date>
    </item>
    <item>
      <title>Eventhouse caching and retention: how do you size the hot cache for dashboards?</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-caching-and-retention-how-do-you-size-the-hot-cache/m-p/5408112#M669</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;We ingest several million events a day into an Eventhouse and have dashboards that mostly look at the last seven days, with occasional investigations going back a year. Our current policy settings are:&lt;/P&gt;&lt;LI-CODE lang="kusto"&gt;.alter table Events policy caching hotdata = 14d
.alter table Events policy retention softdelete = 365d&lt;/LI-CODE&gt;&lt;P&gt;Dashboards are fast, but cost has grown faster than we expected.&lt;/P&gt;&lt;H4&gt;What I would like to hear about&lt;/H4&gt;&lt;UL&gt;&lt;LI&gt;How do you choose the hot cache window: by looking at actual query ranges, or by a fixed rule?&lt;/LI&gt;&lt;LI&gt;Do you keep long-term history in the same table, or move older data to OneLake and query it through a shortcut?&lt;/LI&gt;&lt;LI&gt;How do you check which queries are touching cold data and how much that costs you in latency?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;If you have numbers from before and after changing the cache window, those would be especially useful. Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 10 Nov 2026 17:28:53 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-caching-and-retention-how-do-you-size-the-hot-cache/m-p/5408112#M669</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-10T17:28:53Z</dc:date>
    </item>
    <item>
      <title>Deduplicating streaming events in Eventhouse: materialized view or update policy?</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Deduplicating-streaming-events-in-Eventhouse-materialized-view/m-p/5377659#M664</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I'm looking at how to handle duplicate events in an Eventhouse table that is fed from an Eventstream. The source can resend the same event (same EventId) after retries, so the raw table will contain duplicates.&lt;/P&gt;&lt;P&gt;The two options I keep coming back to are:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;1. A materialized view that keeps the latest record per key&lt;/STRONG&gt;&lt;/P&gt;&lt;LI-CODE lang="none"&gt;.create materialized-view with (backfill=true) EventsDedup on table RawEvents
{
    RawEvents
    | summarize arg_max(IngestionTime, *) by EventId
}&lt;/LI-CODE&gt;&lt;P&gt;&lt;STRONG&gt;2. An update policy into a clean table&lt;/STRONG&gt;, filtering out EventIds that already exist, combined with a short retention on the raw table.&lt;/P&gt;&lt;P&gt;What I'm unsure about:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;At high ingestion rates, does the materialized view keep up reliably, and how do you monitor how far behind it is?&lt;/LI&gt;&lt;LI&gt;Update policies only see the newly ingested batch, so duplicates arriving in different batches can still get through. Is there a common pattern to handle that, or is option 1 generally the safer choice?&lt;/LI&gt;&lt;LI&gt;For downstream Power BI reports in DirectQuery, is it better to query the materialized view directly, or wrap it in a stored function?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;I'd be interested in how others approach this in practice, especially at higher volumes.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 27 Oct 2026 19:38:15 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Deduplicating-streaming-events-in-Eventhouse-materialized-view/m-p/5377659#M664</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-10-27T19:38:15Z</dc:date>
    </item>
    <item>
      <title>Fabric Eventstream MySQL CDC scans all databases and does not emit row-level events</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Fabric-Eventstream-MySQL-CDC-scans-all-databases-and-does-not/m-p/5366400#M651</link>
      <description>&lt;P&gt;Hello Fabric Team,&lt;/P&gt;&lt;P&gt;We are testing the Microsoft Fabric Eventstream MySQL CDC connector with an AWS RDS MySQL database.&lt;/P&gt;&lt;P&gt;The MySQL instance is accessible through a private IP, and Fabric connects through a VNet data gateway/private network connection. Connectivity is successful, and the connector remains Active without reporting processing errors.&lt;/P&gt;&lt;P&gt;Our MySQL environment contains the same table structure across multiple databases, following a pattern similar to:&lt;/P&gt;&lt;P&gt;application_&amp;lt;tenant&amp;gt;.sample_table&lt;/P&gt;&lt;P&gt;We configured the source to capture only one fully qualified table:&lt;/P&gt;&lt;P&gt;application_tenant1.sample_table&lt;/P&gt;&lt;P&gt;The MySQL configuration is:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;log_bin = ON&lt;/LI&gt;&lt;LI&gt;binlog_format = ROW&lt;/LI&gt;&lt;LI&gt;binlog_row_image = FULL&lt;/LI&gt;&lt;LI&gt;The connection user has SELECT, SHOW DATABASES, REPLICATION CLIENT, REPLICATION SLAVE/REPLICA, and the required snapshot permissions.&lt;/LI&gt;&lt;LI&gt;Each Fabric source uses a unique Server ID.&lt;/LI&gt;&lt;LI&gt;CDC from the same RDS instance has previously worked successfully through another CDC platform.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;However, we are seeing the following behavior:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Although only one fully qualified table is selected, Fabric/Debezium scans schema metadata for every accessible database and table on the MySQL server.&lt;/LI&gt;&lt;LI&gt;More than 45,000 schema events were generated across the tenant and history databases.&lt;/LI&gt;&lt;LI&gt;The schema events contain DDL such as DROP TABLE IF EXISTS and CREATE TABLE.&lt;/LI&gt;&lt;LI&gt;Snapshot mode is configured as Initial.&lt;/LI&gt;&lt;LI&gt;The selected table contains approximately 16,000 records, but Fabric emitted zero snapshot r events.&lt;/LI&gt;&lt;LI&gt;We committed a new insert into the selected table after schema discovery finished, but no c event was emitted.&lt;/LI&gt;&lt;LI&gt;Eventhouse receives the schema events successfully, confirming that the source-to-Eventhouse path is operational.&lt;/LI&gt;&lt;LI&gt;The Eventhouse destination stores the Debezium payload in a dynamic column using a mapper from payload to RawEvent.&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Could you please confirm the following?&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Is it expected for the Fabric-managed MySQL CDC connector to scan and publish schema events for every database when only one fully qualified table is selected?&lt;/LI&gt;&lt;LI&gt;Does Fabric expose or support settings equivalent to:&lt;UL&gt;&lt;LI&gt;database.include.list&lt;/LI&gt;&lt;LI&gt;table.include.list&lt;/LI&gt;&lt;LI&gt;schema.history.internal.store.only.captured.databases.ddl&lt;/LI&gt;&lt;LI&gt;schema.history.internal.store.only.captured.tables.ddl&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt;Why would the connector finish schema discovery but not emit existing rows from the selected table when Snapshot mode is Initial?&lt;/LI&gt;&lt;LI&gt;Why are committed inserts not emitted after the schema phase appears to finish?&lt;/LI&gt;&lt;LI&gt;Is there a known limitation involving AWS RDS MySQL accessed through a private IP and VNet data gateway?&lt;/LI&gt;&lt;LI&gt;What is the recommended supported destination pattern for this CDC stream?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Our main objective is reliable ongoing CDC capture. We are flexible about the landing destination and can use:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Eventhouse&lt;/LI&gt;&lt;LI&gt;ADLS Gen2 in JSON or Parquet&lt;/LI&gt;&lt;LI&gt;Fabric Lakehouse/OneLake&lt;/LI&gt;&lt;LI&gt;Snowflake as the final destination&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Please let us know which logs, connector identifiers, timestamps, or additional configuration details would help investigate this behavior.&lt;/P&gt;&lt;P&gt;Thank you.&lt;/P&gt;</description>
      <pubDate>Sat, 12 Sep 2026 09:17:46 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Fabric-Eventstream-MySQL-CDC-scans-all-databases-and-does-not/m-p/5366400#M651</guid>
      <dc:creator>girishtharwani2</dc:creator>
      <dc:date>2026-09-12T09:17:46Z</dc:date>
    </item>
    <item>
      <title>Unable to create a Monitoring Eventhouse in a Microsoft Fabric workspace.</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Unable-to-create-a-Monitoring-Eventhouse-in-a-Microsoft-Fabric/m-p/5365271#M641</link>
      <description>&lt;P&gt;I am trying to enable Workspace Monitoring for a Microsoft Fabric workspace. The user has Fabric Administrator access and is also a Workspace Administrator.&lt;/P&gt;&lt;P&gt;However, under:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Workspace Settings → Monitoring&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;the&amp;nbsp;&lt;STRONG&gt;+ Eventhouse&lt;/STRONG&gt;&amp;nbsp;option is disabled/not available.&lt;/P&gt;&lt;P&gt;We have verified the tenant-level settings and confirmed that&amp;nbsp;&lt;STRONG&gt;“Workspace admins can turn on monitoring for their workspaces”&lt;/STRONG&gt; is enabled.&lt;/P&gt;</description>
      <pubDate>Mon, 07 Sep 2026 12:32:40 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Unable-to-create-a-Monitoring-Eventhouse-in-a-Microsoft-Fabric/m-p/5365271#M641</guid>
      <dc:creator>jonypanchal7</dc:creator>
      <dc:date>2026-09-07T12:32:40Z</dc:date>
    </item>
    <item>
      <title>Changing Ingestions from JSON</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Changing-Ingestions-from-JSON/m-p/5364572#M639</link>
      <description>&lt;P&gt;I have an EventStream receiving IoT Data out of JSONs. In my KQL table the columns timestamp, deviceId and for example x and y exist. The data from one sensor gets ingested in the columns timestamp, deviceId and y. No x since there is no data in the JSON for that. I dont work with a Mapping because it only makes it more complicated and the names in the JSON and in the KQL table are identical.&lt;/P&gt;&lt;P&gt;No I changed the named for data from y to x when creating the JSON. Since there is no mapping and the column already exists in the KQL table the data should be saved now in column x.&lt;/P&gt;&lt;P&gt;My problem is, it doesn't the data is not in x nor in y. It seems to be gone.&lt;/P&gt;&lt;P&gt;Is that a bug in fabric? Can I solve this?&lt;/P&gt;</description>
      <pubDate>Thu, 03 Sep 2026 11:54:06 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Changing-Ingestions-from-JSON/m-p/5364572#M639</guid>
      <dc:creator>MoFabricIoT</dc:creator>
      <dc:date>2026-09-03T11:54:06Z</dc:date>
    </item>
    <item>
      <title>Anomaly Detector is disabled</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Anomaly-Detector-is-disabled/m-p/5360368#M630</link>
      <description>&lt;img /&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;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?&lt;/P&gt;&lt;P&gt;Has anyone faced the same issue?&lt;/P&gt;</description>
      <pubDate>Thu, 20 Aug 2026 11:42:52 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Anomaly-Detector-is-disabled/m-p/5360368#M630</guid>
      <dc:creator>MoFabricIoT</dc:creator>
      <dc:date>2026-08-20T11:42:52Z</dc:date>
    </item>
    <item>
      <title>Eventhouse Capacity Planner minimum CU not reflected in UI/API</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-Capacity-Planner-minimum-CU-not-reflected-in-UI-API/m-p/5358830#M627</link>
      <description>&lt;DIV&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Can anyone confirm:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;&lt;P&gt;Whether the a custom minimum CU value is actually enforced server-side even though the UI/API don't show it, and&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;When UI/API reporting is expected to catch up to reflect the configured minimum?&lt;/P&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Any insight or similar experience would be appreciated.&lt;/P&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 13 Aug 2026 09:38:53 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Eventhouse-Capacity-Planner-minimum-CU-not-reflected-in-UI-API/m-p/5358830#M627</guid>
      <dc:creator>WorkFull22</dc:creator>
      <dc:date>2026-08-13T09:38:53Z</dc:date>
    </item>
    <item>
      <title>Fabric Eventhouse: Capacity policy for .ingest inline is hard-capped at 1 concurrent operation</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Fabric-Eventhouse-Capacity-policy-for-ingest-inline-is-hard/m-p/5316134#M614</link>
      <description>&lt;H2&gt;Problem&lt;/H2&gt;&lt;P&gt;When using the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;KQL Activity&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;in Fabric Data Pipelines to execute&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A title="" target="_blank"&gt;&lt;SPAN class=""&gt;.ingest inline&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;commands against an Eventhouse KQL database, the effective ingestion capacity is always&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;1 concurrent operation&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;— regardless of the Fabric capacity SKU (tested on F2 and F8) and regardless of the cluster capacity policy setting.&lt;/P&gt;&lt;P&gt;Running&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;.alter-merge cluster policy capacity&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;with&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ClusterMaximumConcurrentOperations: 16&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;succeeds without error, but&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;.show capacity&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;still reports an effective ingestion capacity of 1.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any pipeline pattern that executes&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A title="" target="_blank"&gt;&lt;SPAN class=""&gt;.ingest inline&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;within a parallel&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ForEach&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;immediately hits&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;429 TooManyRequests&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;/&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ControlCommandThrottledException&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;errors. Highlighting that the capacity is 1.&lt;/P&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;P&gt;This makes the KQL Activity (KustoQueryLanguage&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;type) unusable for parallel ingestion scenarios — which is an important use case in data pipelines (logging, event emission, watermark updates during parallel table processing).&lt;/P&gt;&lt;H2&gt;Question / Request&lt;/H2&gt;&lt;P&gt;Do you recognize this issue? if so I have the below request:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Increase the effective ingestion capacity&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;for Fabric Eventhouse to match what the capacity policy allows (respect&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;ClusterMaximumConcurrentOperations)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 23 Jul 2026 11:24:09 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Fabric-Eventhouse-Capacity-policy-for-ingest-inline-is-hard/m-p/5316134#M614</guid>
      <dc:creator>hal-apeno91</dc:creator>
      <dc:date>2026-07-23T11:24:09Z</dc:date>
    </item>
    <item>
      <title>Delay in Onelake Shortcut from Eventhouse to Lakehouse</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Delay-in-Onelake-Shortcut-from-Eventhouse-to-Lakehouse/m-p/5282649#M605</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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 work&lt;/P&gt;</description>
      <pubDate>Thu, 09 Jul 2026 21:14:12 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Delay-in-Onelake-Shortcut-from-Eventhouse-to-Lakehouse/m-p/5282649#M605</guid>
      <dc:creator>Shashwot</dc:creator>
      <dc:date>2026-07-09T21:14:12Z</dc:date>
    </item>
    <item>
      <title>BCDR support for Fabric Eventhouse (KQL DB) – cross-region data replication and failover</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/BCDR-support-for-Fabric-Eventhouse-KQL-DB-cross-region-data/m-p/5193842#M601</link>
      <description>&lt;P&gt;Hi team,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;A few quick questions regarding BCDR options for Fabric Eventhouse (KQL):&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Does &lt;STRONG&gt;Fabric Eventhouse &lt;/STRONG&gt;provide&lt;STRONG&gt; built-in cross-region redundancy/failover &lt;/STRONG&gt;in case of regional outages?&lt;UL&gt;&lt;LI&gt;If yes, what is required to implement this, and what does the &lt;STRONG&gt;cost model&lt;/STRONG&gt; look like?&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt;Does &lt;STRONG&gt;Fabric &lt;/STRONG&gt;support &lt;STRONG&gt;native data replication/ copy &lt;/STRONG&gt;capabilities&lt;STRONG&gt;?&lt;/STRONG&gt;&lt;BR /&gt;Specifically, is there support (or a roadmap) for:&lt;OL&gt;&lt;LI&gt;Azure Data Explorer (&lt;STRONG&gt;ADX/Kusto&lt;/STRONG&gt;) → Fabric &lt;STRONG&gt;Eventhouse&lt;/STRONG&gt; (KQL DB)&lt;/LI&gt;&lt;LI&gt;Fabric &lt;STRONG&gt;Eventhouse&lt;/STRONG&gt; (KQL DB) → Fabric &lt;STRONG&gt;Eventhouse&lt;/STRONG&gt; (KQL DB) &lt;STRONG&gt;across regions&lt;/STRONG&gt; (e.g., westcentralus ↔ westus)&lt;/LI&gt;&lt;/OL&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Could you please share any relevant documentation, known limitations, or guidance for these scenarios?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance for your help!&lt;/P&gt;</description>
      <pubDate>Fri, 05 Jun 2026 23:54:27 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/BCDR-support-for-Fabric-Eventhouse-KQL-DB-cross-region-data/m-p/5193842#M601</guid>
      <dc:creator>egirma</dc:creator>
      <dc:date>2026-06-05T23:54:27Z</dc:date>
    </item>
    <item>
      <title>DataFlow Gen 2 with KQL Engine Query URI as the destination</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/DataFlow-Gen-2-with-KQL-Engine-Query-URI-as-the-destination/m-p/5181536#M592</link>
      <description>&lt;P&gt;I'm trying to implement the Content Delivery Lifecycle using workspace Git integration- see&amp;nbsp;&lt;A href="https://learn.microsoft.com/en-us/fabric/cicd/git-integration/intro-to-git-integration" target="_blank" rel="noopener"&gt;https://learn.microsoft.com/en-us/fabric/cicd/git-integration/intro-to-git-integration&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I need the destination of my Data Flow to automatically pick up the right KQL Engine instance + connection, here:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;I can make it pick up the cluster URI from a library variable as show above. However, the problem that I have is that the connection name does not populate (also shown above).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I run the Data Flow (in this state) I get the error below:&lt;/P&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 12 May 2026 13:38:33 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/DataFlow-Gen-2-with-KQL-Engine-Query-URI-as-the-destination/m-p/5181536#M592</guid>
      <dc:creator>AndrewPage</dc:creator>
      <dc:date>2026-05-12T13:38:33Z</dc:date>
    </item>
    <item>
      <title>Unable to connect to the Data source in storage account using get data in fabric kql database</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Unable-to-connect-to-the-Data-source-in-storage-account-using/m-p/5158405#M585</link>
      <description>&lt;P&gt;Hello, i am completing the Applied Skills assessment "Implement Real-Time Intelligence with Microsoft Fabric" and I am blocked on the task that requires importing a CSV file from the Azure Blob Storage into a KQL database using Get Data and selecting Azure Storage.&lt;/P&gt;&lt;P&gt;The only available authentication method is Workspace Identity, however when I attempt to save the connection I receive the error: "AuthKind WorkspaceIdentity did not have accessToken specified."&lt;/P&gt;&lt;P&gt;I found that:&lt;/P&gt;&lt;P&gt;The Fabric workspace identity has no role assignment on the storage account and i can't&lt;/P&gt;&lt;P&gt;select the "Add role assignment" button in Azure IAM because it is disabled — I cannot grant Storage Blob Data Reader to the workspace identity which is i assume is required to be able to connect to the blob storage&lt;/P&gt;&lt;P&gt;There are no alternative authentication methods available so i'm stuck on what to do.&lt;img /&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 25 Apr 2026 16:38:54 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Unable-to-connect-to-the-Data-source-in-storage-account-using/m-p/5158405#M585</guid>
      <dc:creator>HatSal</dc:creator>
      <dc:date>2026-04-25T16:38:54Z</dc:date>
    </item>
    <item>
      <title>Is there a way to deactivate an Eventhouse/KQL DB?</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Is-there-a-way-to-deactivate-an-Eventhouse-KQL-DB/m-p/4907141#M578</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Is there a way to do this?&lt;/P&gt;</description>
      <pubDate>Mon, 22 Dec 2025 15:59:15 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Is-there-a-way-to-deactivate-an-Eventhouse-KQL-DB/m-p/4907141#M578</guid>
      <dc:creator>arpost</dc:creator>
      <dc:date>2025-12-22T15:59:15Z</dc:date>
    </item>
    <item>
      <title>T-SQL executing directly in Eventhouse KQL Queryset without comment (--) prefix</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/T-SQL-executing-directly-in-Eventhouse-KQL-Queryset-without/m-p/4899610#M569</link>
      <description>&lt;P class=""&gt;Hey everyone,&lt;/P&gt;&lt;P class=""&gt;I was just exploring Eventhouse and noticed something weird. The docs say you need to add "&lt;STRONG&gt;--"&lt;/STRONG&gt; on its own line before T-SQL queries in KQL querysets, but I'm running T-SQL commands just fine without it.&lt;/P&gt;&lt;P class=""&gt;I never added the "&lt;STRONG&gt;--"&lt;/STRONG&gt;&amp;nbsp;prefix and all T-SQL queries executed normally.&lt;/P&gt;&lt;P class=""&gt;Is this a recent change? The documentation still mentions needing the comment prefix to switch to T-SQL mode, but it seems like the query editor is just auto-detecting it now?&lt;BR /&gt;&lt;STRONG&gt;Reference:&lt;/STRONG&gt; &lt;A href="https://learn.microsoft.com/en-us/kusto/query/t-sql?view=microsoft-fabric" target="_blank" rel="noopener"&gt;https://learn.microsoft.com/en-us/kusto/query/t-sql?view=microsoft-fabric&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 11 Dec 2025 10:53:10 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/T-SQL-executing-directly-in-Eventhouse-KQL-Queryset-without/m-p/4899610#M569</guid>
      <dc:creator>Ruchi23</dc:creator>
      <dc:date>2025-12-11T10:53:10Z</dc:date>
    </item>
    <item>
      <title>kusto error- partial query failure</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/kusto-error-partial-query-failure/m-p/4870803#M564</link>
      <description>&lt;P&gt;hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;error -&amp;nbsp;Details: "Query execution has exceeded the allowed limits (80DA0001): Partial query failure: Runaway query (E_RUNAWAY_QUERY). (message: The Join output block has exceeded the memory budget during evaluation. Results may be incorrect or incomplete (E_RUNAWAY_QUERY; see &lt;A href="https://aka.ms/kustoquerylimits" target="_blank"&gt;https://aka.ms/kustoquerylimits&lt;/A&gt;).: ).&lt;BR /&gt;[0]Kusto.Data.Exceptions.KustoServicePartialQueryFailureLimitsExceededException: Query execution has exceeded the allowed limits (80DA0001): Partial query failure: Runaway&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am trying to join 5 tables in kusto to fetch all required columns , 3 tables from 1 cluster ans 2 from another cluster. But query is failing with memory error&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Dummy query :&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;let onboarded = Pln&lt;BR /&gt;| project STId;&lt;/P&gt;&lt;P&gt;let regAss = external_table('PR')&lt;BR /&gt;| where Region == 'France'&lt;BR /&gt;| where Status !in ("Error", "Rejected")&lt;BR /&gt;| project STId;&lt;/P&gt;&lt;P&gt;let exeAppr = external_table('PR')&lt;BR /&gt;| where Region == "France" and Status in ("Ready", "Approved")&lt;BR /&gt;| project STId, Region, Status;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;let QReferenced= external_table('PQR')&lt;BR /&gt;| where Region == 'France' and Status == "Completed"&lt;BR /&gt;| project STId, Region, Status,RequestId;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;let Regionpsllls = cluster("cp.ws.kusto.windows.net").database("pslll").pslll&lt;BR /&gt;| where State == "Active" and pslllType == "Region"&lt;BR /&gt;| project pslllId, pslllName = Name, pslll_Reg = RegionName;&lt;/P&gt;&lt;P&gt;let pslllServices = cluster("cp.ws.kusto.windows.net").database("pslll").PFL&lt;BR /&gt;| where ProductType == "Service"&lt;BR /&gt;| project pslllId, SOId;&lt;/P&gt;&lt;P&gt;let pslll_Reg_Serv = Regionpsllls&lt;BR /&gt;| join kind=inner pslllServices on pslllId&lt;BR /&gt;| project pslll_Reg, pslllName, SOId;&lt;/P&gt;&lt;P&gt;// Join onboarded with pslll&lt;BR /&gt;let Onboardedpslll = onboarded&lt;BR /&gt;| join kind=inner pslll_Reg_Serv on $left.STId == $right.SOId;&lt;/P&gt;&lt;P&gt;// Join region assigned with pslll&lt;BR /&gt;let regAsspslll = regAss&lt;BR /&gt;| join kind=inner pslll_Reg_Serv on $left.STId == $right.SOId;&lt;/P&gt;&lt;P&gt;// Join execution approved with pslll&lt;BR /&gt;let exeApprpslll = exeAppr&lt;BR /&gt;| join kind=inner pslll_Reg_Serv on ($left.STId == $right.SOId and $left.Region == $right.pslll_Reg);&lt;/P&gt;&lt;P&gt;//join quota refernced with pslll&lt;BR /&gt;let QReferencedpslll = QReferenced&lt;BR /&gt;| join kind=inner pslll_Reg_Serv on ($left.STId == $right.SOId and $left.Region == $right.pslll_Reg);&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;// Combine using inner joins (only psllls present in all three sets)&lt;BR /&gt;Onboardedpslll&lt;BR /&gt;| join kind=inner regAsspslll on pslll_Reg, pslllName&lt;BR /&gt;| join kind=inner exeApprpslll on pslll_Reg, pslllName&lt;BR /&gt;| join kind=inner QReferencedpslll on pslll_Reg, pslllName&lt;BR /&gt;| project pslll_Reg, pslllName ( i want many more cols to project)&lt;/P&gt;</description>
      <pubDate>Mon, 10 Nov 2025 09:39:50 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/kusto-error-partial-query-failure/m-p/4870803#M564</guid>
      <dc:creator>Sania-F</dc:creator>
      <dc:date>2025-11-10T09:39:50Z</dc:date>
    </item>
    <item>
      <title>Azure resource graph and KQL</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Azure-resource-graph-and-KQL/m-p/4845601#M556</link>
      <description>&lt;P&gt;Hi Everyone,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am trying to find the right data for compute resources (ex -Virtual machine allocated cores versus used cores for all the subscribtions and quite other things allocation and usage ) .&lt;/P&gt;&lt;P&gt;I need to use kusto explorer/ ADX for analyzing this data. I cannot run queries&amp;nbsp; in azure portal for same. The kql returns data in json format.&amp;nbsp; The challenge is ARG, kusto, kql. All these 3 things are new to me. So how do I start to identify the infrastructure compute data allocated, used and write queries that could be used in reporting tools.&lt;/P&gt;</description>
      <pubDate>Wed, 08 Oct 2025 13:51:06 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Azure-resource-graph-and-KQL/m-p/4845601#M556</guid>
      <dc:creator>Sania-F</dc:creator>
      <dc:date>2025-10-08T13:51:06Z</dc:date>
    </item>
    <item>
      <title>Restricted View Policy Bug</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Restricted-View-Policy-Bug/m-p/4838392#M537</link>
      <description>&lt;P&gt;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?&lt;/P&gt;</description>
      <pubDate>Mon, 29 Sep 2025 23:02:18 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Restricted-View-Policy-Bug/m-p/4838392#M537</guid>
      <dc:creator>haku99</dc:creator>
      <dc:date>2025-09-29T23:02:18Z</dc:date>
    </item>
    <item>
      <title>Partitioning policy is not copied to DatabaseSchema.kql</title>
      <link>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Partitioning-policy-is-not-copied-to-DatabaseSchema-kql/m-p/4837782#M535</link>
      <description>&lt;P&gt;I have added a custom&amp;nbsp;partitioning policy to some materialized views and tables like this:&lt;/P&gt;&lt;LI-CODE lang="javascript"&gt;.alter materialized-view DimResponse policy partitioning "{\"PartitionKeys\":[{\"ColumnName\":\"OrgId\",\"Kind\":\"Hash\",\"Properties\":{\"Function\":\"XxHash64\",\"MaxPartitionCount\":128,\"Seed\":1,\"PartitionAssignmentMode\":\"Uniform\"}}],\"EffectiveDateTime\":\"2023-01-01T00:00:00.000000Z\",\"MinRowCountPerOperation\":0,\"MaxRowCountPerOperation\":0,\"MaxOriginalSizePerOperation\":0}"&lt;/LI-CODE&gt;&lt;P&gt;I have connected to source control, but in&amp;nbsp;DatabaseSchema.kql, the policy is not in the schema, is this a limitation or a bug?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My update policies are applied in the&amp;nbsp;DatabaseSchema.kql, so something is working when altering&amp;nbsp;materialized views and tables.&lt;/P&gt;</description>
      <pubDate>Mon, 29 Sep 2025 10:59:25 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Eventhouse-and-KQL/Partitioning-policy-is-not-copied-to-DatabaseSchema-kql/m-p/4837782#M535</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2025-09-29T10:59:25Z</dc:date>
    </item>
  </channel>
</rss>

