real-time dashboard

22 Topics

Unable to create a Monitoring Eventhouse in a Microsoft Fabric workspace.
I am trying to enable Workspace Monitoring for a Microsoft Fabric workspace. The user has Fabric Administrator access and is also a Workspace Administrator. However, under: Workspace Settings → Monitoring the + Eventhouse option is disabled/not available. We have verified the tenant-level settings and confirmed that “Workspace admins can turn on monitoring for their workspaces” is enabled.
jonypanchal7
23 hours ago Place Eventhouse and KQL
71Views
1like
6Comments
kusto error- partial query failure
hi all, error - 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 https://aka.ms/kustoquerylimits).: ). [0]Kusto.Data.Exceptions.KustoServicePartialQueryFailureLimitsExceededException: Query execution has exceeded the allowed limits (80DA0001): Partial query failure: Runaway 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 Dummy query : let onboarded = Pln | project STId; let regAss = external_table('PR') | where Region == 'France' | where Status !in ("Error", "Rejected") | project STId; let exeAppr = external_table('PR') | where Region == "France" and Status in ("Ready", "Approved") | project STId, Region, Status; let QReferenced= external_table('PQR') | where Region == 'France' and Status == "Completed" | project STId, Region, Status,RequestId; let Regionpsllls = cluster("cp.ws.kusto.windows.net").database("pslll").pslll | where State == "Active" and pslllType == "Region" | project pslllId, pslllName = Name, pslll_Reg = RegionName; let pslllServices = cluster("cp.ws.kusto.windows.net").database("pslll").PFL | where ProductType == "Service" | project pslllId, SOId; let pslll_Reg_Serv = Regionpsllls | join kind=inner pslllServices on pslllId | project pslll_Reg, pslllName, SOId; // Join onboarded with pslll let Onboardedpslll = onboarded | join kind=inner pslll_Reg_Serv on $left.STId == $right.SOId; // Join region assigned with pslll let regAsspslll = regAss | join kind=inner pslll_Reg_Serv on $left.STId == $right.SOId; // Join execution approved with pslll let exeApprpslll = exeAppr | join kind=inner pslll_Reg_Serv on ($left.STId == $right.SOId and $left.Region == $right.pslll_Reg); //join quota refernced with pslll let QReferencedpslll = QReferenced | join kind=inner pslll_Reg_Serv on ($left.STId == $right.SOId and $left.Region == $right.pslll_Reg); // Combine using inner joins (only psllls present in all three sets) Onboardedpslll | join kind=inner regAsspslll on pslll_Reg, pslllName | join kind=inner exeApprpslll on pslll_Reg, pslllName | join kind=inner QReferencedpslll on pslll_Reg, pslllName | project pslll_Reg, pslllName ( i want many more cols to project)
Solved
Sania-F
9 months ago Place Eventhouse and KQL
7.8KViews
0likes
4Comments
RTI Dashboard: Can we have shorter legend, color customization , 3 dimensional view in single tile
I have few questions with respect to RTI Dashboard 1. Can I have a shorter meaninful legend in charts ?For example, in the line chart below, where I'm displaying the complaint count over time for different ComplaintStatus categories, the current legend is unclear and hard to read. I would like the legend to indicate that Red represents "New," Blue represents "In Progress," and another color represents "Resolved." Below is the query i have used to build the linechart: silver_querystatuses | where todatetime(StatusDate) between (_startTime .. _endTime) | extend RoundedTime = bin(StatusDate, 1h) // Group into 15-minute intervals | where QueryStatus in ("New", "In Progress", "Resolved") | summarize Count = count() by RoundedTime, QueryStatus | project RoundedTime, Count, ["Complaints"] = QueryStatus | order by RoundedTime asc; 2. And also at the moment, there are two lines under the blue color family, which also causes confusion and sometimes its hard to differentiate. Is there a way to customize the color? 3. Can we have a 3 dimensional view (3 variables in 1 tile), like one representing a line chart and other bar chart in the same tile. You can suggest some view too if its possible 4. I have enabled OneLake Availability for the tables in my KQL , I see the parquet files are created under the KQL tables in Files section and not in Lakehouse. How can i connect to these parquet files in Direct Lake mode in PowerBI. My end goal is to connect PowerBI to these parquet files instead of KQL tables directly. 5. Tried using copilot in KQL eventhouse, but the Copilot doesnt considers the tables that have come as shortcut(external table) from my LH while building the query.
Solved
sshetty014
1 year ago Place Eventhouse and KQL
9.9KViews
0likes
8Comments
How can I split a variable-depth, slash-delimited path_column field into separate col in KQL?
Q : How can I split a variable-depth, slash-delimited path_column field into separate path_lvl_1, path_lvl_2, … columns in Kusto (Fabric) so that Power BI (in DirectQuery mode) can consume a fixed schema without requiring manual updates when the number of segments grows? Details: My raw table is named data_table and has this schema: id_column : string device_column : string event_name : string data_type : string unit_column : string path_column : string // e.g. "A/B/C/D" or "X/Y" or "Region/Zone/Section/Shelf/…" value_column : string timestamp_column : datetime static_flag : bool message_type : string path_column can have an arbitrary number of “/” segments—today might be 3 levels, tomorrow 10 or 50. We need Power BI (in DirectQuery) to see columns like: path_lvl_1, path_lvl_2, path_lvl_3, …, path_lvl_N where N grows automatically whenever any row’s path_column has more segments than before. Approaches tried and limitations: Split to a dynamic array (extend segments_array = split(path_column, "/")) then client-side “List → Record → Expand.” Works in Import mode, but breaks in DirectQuery because the M step (using List.Count, Record.FromList, Expand) cannot fold. Split into a fixed number of columns (e.g. assume max of 10 levels via path_lvl_1 = iff(array_length(parts) >= 1, parts[0], ""), …, path_lvl_10 = iff(array_length(parts) >= 10, parts[9], "")). Works in DirectQuery, but if a row ever has 11 segments, you lose data beyond level 10—and must manually alter the function/table to add path_lvl_11. mv-expand + evaluate pivot at query time for a truly dynamic set of columns. KQL function returns a result with as many columns as needed (0..max index), but the schema is not stable, so Power BI (DirectQuery) cannot bind to it. What I need: A way in Fabric/Kusto to produce a “wide” result that always has a fixed schema of path_lvl_1…path_lvl_N, automatically increasing N whenever deeper paths appear—without having to manually ALTER the table or function each time the maximum depth increases. Ideally, a pure KQL solution (since DirectQuery won’t let me do client-side M transformations), or some Fabric feature I’m missing (update policies, etc.) that can “auto-add” new columns. Why this matters: We want the Fabric → Power BI pipeline to be maintenance-free. If tomorrow a device reports path_column = "A/B/C/D/E/F/G/H" the next Power BI refresh should automatically see path_lvl_7 and path_lvl_8 without a manual “.alter table” or “re-publish function.” Actually I need these different columns to create hierarchy in one of power bi report. so that the dynamic schema can be handled properly. or if you can provide a solution to handle it at etl level, that will also work, like may be implementing any function or script so that if each time no of values getting inccreased in path_column, then automatically functions or script run and creates same table with new schema with updated policy. Has anyone in the Fabric community solved this? Is there a recommended pattern to handle truly variable-depth slash-delimited hierarchies in KQL so that downstream Power BI (DirectQuery) always sees a stable, “growing” set of path_lvl_X columns?
Solved
ramankr48
1 year ago Place Eventhouse and KQL
7.2KViews
0likes
9Comments
RTI Dashboard Is Showing Errors on Visuals: "Unable to read data from the transport connection:"
I have an RTI Dashboard connected to an EventHouse. All of the visuals that are connected to one specific table are showing the same error, which is: 'Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..' The DB shows no errors though and loads correctly: Anyone know what might be happening? It was all working yesterday and no changes were made except for new data flowing in.
Solved
Kelderic
1 year ago Place Eventhouse and KQL
4.7KViews
0likes
4Comments
I want to achieve a chart in real time dashboard where metrics and chart both should there
Hi Team I am trying to create a chart where i want keep the metrics and chart both in a single tile, is it possible or not if yes can you help me through it, i am trying with plotly also but got nothing till now attaching sc of requirement and slo one more thing there is a chart where 3 stocks live data is coming , so i want the each graph to be separated by one other like same in above sc instead of giving the combined chart together
Solved
ramankr48
1 year ago Place Eventhouse and KQL
5.7KViews
0likes
5Comments
Real Time Intelligence - Dashboard Refresh Rate
Hi everyone, I have a question regarding the refresh behavior of real-time dashboards in Fabric. I'm currently using the trial capacity (F64), and in the real-time dashboard settings, under the auto-refresh option, there's a mode labeled "continuous." Q. I'm curious — is there a fixed refresh interval happening in the background (e.g., every 1 second), or does the dashboard update purely based on when new data arrives? Q. Additionally, are there any other ways — within Real-Time Intelligence or Power BI — to configure dashboards to refresh multiple times per second? I'm open to any suggestions. Our requirement is to implement a solution (using Power BI, Fabric, or any other suitable tool/tech) where dashboard visuals can update several times per second, if possible. Thanks in advance for your insights!
Solved
ramankr48
1 year ago Place Eventhouse and KQL
7.7KViews
0likes
6Comments
Can we implement RLS(row level security) in real time when data is getting streamed into destination
Hi Community Members, Can we implement real time RLS in real time intelligence, when data is getting streamed into the eventhouse or lakehouse or any supported destination ? Is it possible to implement in the transformation phase or later part Like i have one use case where i am getting real time data and i need to store those data into the destination say lakehouse but also maiantaining thr security (RLS), and then I am using this data to make the real time dashboard, where the refresh will happen very often while maintaining the data security.
Solved
ramankr48
1 year ago Place Eventhouse and KQL
4.3KViews
2likes
2Comments
Real time data transformation options
I am trying to understand what are the all possible transformation options available for real time data. After studying real time intelligence experience in fabric, I can pin point few of them 1. Transformation available in Eventstream 2. KQL update policy ( not possible, when using joins ) Apart from this , did I miss something, please suggest. At the core, I am looking how can I transform data using medallion architecture. For bronze we can leverage update policy, for silver to gold , we can leverage materzied views. Issue arises in silver layer, as join doesnt fully support update policy (streaming ingestion need to be disabled). This makes difficult to perform joins. Is there any other approach to process real time data. Please suggest your thoughts folks, also please correct me if I am wrong.
Solved
chetanhiwale
1 year ago Place Eventhouse and KQL
9.8KViews
2likes
8Comments
can i customize the color displayed in the bar chart in Real time dashbaord in Fabric
Hi I have couple of questions with Real time dashboard in fabric 1. I am looking for a solution where i can swap the color of the bars in my below bar chart. In the Visual i couldnt find any settings to do so, also programatically i was not able to find a solution for it . I tried using Hex Code but that did not help 2. If you see the above legend I can see that it displays QueryStatus:Cancelled:Percentage , but I dont want to show Percentage keyword in the legend , how to achieve this. below is the query Im using for the above chart let lookup = silver_customerqueries | join kind=inner external_table('querytypes') on QueryTypeID | join kind=inner silver_querystatuses on QueryID | extend QueryStatus = case( QueryStatus in ("In Progress", "New", "Escalated"), "Unresolved", QueryStatus ) | project QueryID, OrderItemID, QueryTypeID, QueryType, QueryStatus; lookup | summarize Count = count() by QueryType, QueryStatus | join kind=inner (lookup | summarize TotalCount = count() by QueryType) on QueryType | extend Percentage = round(100 * Count / TotalCount, 2) | project QueryType, QueryStatus, Percentage
Solved
sshetty014
1 year ago Place Eventhouse and KQL
2.1KViews
0likes
1Comment