Forum Discussion

Kraftfood's avatar
Kraftfood
Helper I
8 months ago
Solved

Composite-model performance issue

Hello, I am encountering a performance issue due to (thank GPT) composite model. I have a PBI pro license and the workspace I use has a Premium Per Capacity license Situation: I have downloaded a s...
  • rohit1991's avatar
    8 months ago

    Hii Kraftfood 

     

    Joining a DirectQuery-to-AS semantic model with local Excel tables forces Power BI to run cross-engine queries, create large intermediate results, and compute filters in both places there is no fast path. The only real fix is to avoid the local Excel tables and keep everything inside one semantic model.