You have an Azure event hub. Each event contains the following fields: BikepointID Street Neighbourhood Latitude Longitude No_Bikes No_Empty_Docks You need to ingest the events. The solution must…

A KQL queryset is used for querying data already stored in a KQL database, not for ingesting and transforming data from an Event Hub into a lakehouse.

A Fabric eventstream provides an end-to-end solution for ingesting real-time data from sources like Azure Event Hubs, applying transformations such as filtering events where Neighbourhood is 'Chelsea', and routing the processed data to destinations like a Fabric lakehouse. It is designed for this exact real-time data processing and storage scenario within Fabric.

A streaming dataset in Power BI is primarily for real-time dashboards and visualization, not for ingesting raw event hub data, applying complex transformations, and then storing it in a lakehouse.

Apache Spark Structured Streaming can perform this task, but within the Microsoft Fabric ecosystem, an eventstream offers a more integrated and often simpler low-code/no-code experience specifically for real-time ingestion, transformation, and routing to Fabric destinations.