Anomaly Detection
Hi, The walkthrough for real-time analysis in Fabric has the query below as an example of anomaly detection in taxi driver tips in New York: nyctaxitrips | lookup (Locations) on $left.PULocationID==$right.LocationID | where Borough == "Manhattan" | make-series s1 = avg(tip_amount) on tpep_pickup_datetime from datetime(2022-06-01) to datetime(2022-06-04) step 1h | extend anomalies = series_decompose_anomalies(s1) | render anomalychart with (anomalycolumns=anomalies) What bothers me is that the detection is made over an average, so we are not really detecting the anomaly, we are detecting the hour inside which the anomaly happened. The make-series only work with an aggregation function. Is it possible to use series_decompose_anomalies to detect individual anomaly values, instead of aggregated anomaly values? How could we use the make series without aggregation? The example contained in the description page of the function series_decompose_anomalies is about web traffic and makes complete sense, because there is no anomaly on an individual value, it only exists on an aggregation. But for taxi driver tips, there is one anomaly and we can't find it aggregating. Of course I could use separate queries over the hours pointed as anomaly to discover which is the anomaly value, but I was willing to find a solution to see the anomalies in a chart with a query. Am I wrong? Is my concept wrong? Kind Regards, Dennes
KQL Shortcut OneLake Option Missing
Hi there - We want to process data from Azure Data Explorer (Kusto). using Spark. I have created shortcut using this Create a database shortcut - Microsoft Fabric | Microsoft Learn . However, I don't see option for creating shorcut on top of KQL Shortcut database i.e I want to access this data under Lakehouse using externaltable option in order to process using spark. Created ShortCut using Azure Data Explorer (Kusto). Create a database shortcut - Microsoft Fabric | Microsoft Learn OneLakeAvailability Option: I can see OneLake Availablity Option for new kql database created in Fabric but it's missig in Above Screenshot Please suggest how to resolve the issue. Thanks, Abhiram
Fabric - Real Time Analytics - Cannot create connection to external event hub
Hi, I am having trouble when adding an external event hub (from a different tenant). The problem is occuring when trying to create the connection to the event hub. I am using the name of the event hub namspace, and not the entire domain of the event hub namespace I have tried using the SAS credentials on both the event hub namespace and the event hub instance. The SAS keys have Manage permission. I get the following error message when I try to connect using both the SAS credentials for the event hub instance and the event hub namespace After I have created the connection (even though it failed to create as mentioned above, it still occurs in the list of connections for the event hub source), it gets this error. The SAS key have Manage permission. Would gladly appreciate if anyone can assist me. Thanks! -Bjarte
