microsoft / microsoft/finops-toolkit

Error when trying to build the Semantic Model for Power BI

Open
#1,968 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Needs: Attention 👋 Resolution: External Skill: Deployment Tool: Power BI
Dominant language
PowerShell
Stars
603
Forks
248
Avg merge
7d 11h
Merged PRs (30d)
11

Description

🐛 Problem

After adding historical data the semantic model fails to build with the following error:

Data source error: Expression.Error: Query execution lacks memory resources to complete (80DA0007): Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation (E_LOW_MEMORY_CONDITION)', details: '').
[0]Kusto.Data.Exceptions.KustoServicePartialQueryFailureLowMemoryConditionException: Query execution lacks memory resources to complete (80DA0007): Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation (E_LOW_MEMORY_CONDITION)', details: '').
Timestamp=2026-01-29T21:27:41.9276181Z
ClientRequestId=KPBI;da28ac00-f5fc-4ba7-9df5-2ecb44a9b174;3138df23-7f3e-4884-88bf-4413de5280c2;2ebdf4a5-c6ca-4efb-a9ac-775f33162a27
ActivityId=e934732f-a425-4efd-a1c0-2560369e3f8a
ActivityType=GW.Http.CallContext
ServiceAlias=KUTRIDENTHOSTEREUS2
MachineName=KEngine00000T
ProcessName=Kusto.WinSvc.Svc
ProcessId=3200
ThreadId=10740
ActivityStack=(Activity stack: CRID=KPBI;da28ac00-f5fc-4ba7-9df5-2ecb44a9b174;3138df23-7f3e-4884-88bf-4413de5280c2;2ebdf4a5-c6ca-4efb-a9ac-775f33162a27 ARID=e934732f-a425-4efd-a1c0-2560369e3f8a > GW.Http.CallContext/e934732f-a425-4efd-a1c0-2560369e3f8a)
MonitoredActivityContext=(ActivityType=GW.Http.CallContext, Timestamp=2026-01-29T21:27:25.0945493Z, ParentActivityId=e934732f-a425-4efd-a1c0-2560369e3f8a, TimeSinceStarted=16833.0738 [ms])ErrorCode=
ErrorReason=
ErrorMessage=
DataSource=
DatabaseName=
ClientRequestId=
ActivityId=00000000-0000-0000-0000-000000000000
UnderlyingErrorCode=80DA0007
UnderlyingErrorMessage=Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation (E_LOW_MEMORY_CONDITION)', details: '')

. . The exception was raised by the IDbCommand interface.
Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID: fba2f2a1-2c56-4e2d-b59b-08d1b32b2421
Request ID: 20039106-b14f-8d31-9dd2-f0cc7eb9cd55
Time: 2026-01-29 21:27:42Z

👣 Repro steps

TODO: Add repro steps below:

  1. Deploy FinOps Hubs in Fabric
  2. Export historical data for ~ 1 year (13GB worth of data)
  3. Build the Semantic Model
  4. See error

🤔 Expected

Semantic model should builds successfully after ingesting the historical data

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files or tests are named. Start by reproducing the failure using FinOps Hubs in Fabric with about one year of historical data, then investigate the Semantic Model build path and the reported low-memory Kusto error. Done means the Semantic Model builds successfully after ingesting the historical data.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
cloud, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.