What is KQL db in fabric generally used for storing, is it historical data or only streaming data?
Hi, I wanted to understand if usually end users utilize KQL db in fabric for storing historical data as well or only streaming data. What is usual retention period commonly followed for KQL db as the default is unlimited. Thanks in advance.
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
Gets "code":"Unauthorized" error when accessing one lake in microsoft fabric
I created a KQL database which has event hub as the source and I can see the data in the KQl table I created. However , after activating the One lake path and I try to open it in new window. I get the below error: {"error":{"code":"Unauthorized","message":"Authentication Failed with Bearer token is not present in the request"}} What wrong am I doing. What permission do I need to check. couldnt find in Fabric documentation anything on generating tokenQueries on KQL tables are not executing
I tried querying a KQL table that was created from a text file, to no avail. When I use the "Query table" option on the table and then "Show Any 100 Records", the query pane opens but nothing happens. Also when I do that a few consecutive times, the query is being added to the previous one resulting in having the same query multiple times in the query pane. Howerver, the query still doesn't execute and clicking the Cancel button also doesn't work.A Typo when query a table in KQL DB (in Korean)
Hi, Team While creating a KQL database and querying a table, I found a typo. We don’t understand ‘쿼리 테이블’(Query table). The ‘Query’ is a clear verb. Like ‘Get’ for Get data. It means selecting data from a table. So that should be ‘테이블 조회’ or ‘테이블 쿼리’. Korean English Thanks, Hong
