When Trying to Use Nested Composite Model Facing Error or Performance Issues

Hi Anonymous ,

To use composite model, you should consider the data source and connection mode. For example, import mode composite, direct query composite, import and direct query composite.

Refer: Use composite models 

Using composite models adds additional performance considerations. A single visual can result in sending queries to multiple sources, which often pass the results from one query across to a second source. This situation can result in the following forms of execution:

• An SQL query that includes a large number of literal values

• An SQL query that queries at a lower level of granularity, with the data later being aggregated locally

• Multiple SQL queries, one per group by value

Additionally, the use of many-to-many relationships means that separate queries must be sent to the underlying source for each total or subtotal level, rather than aggregating the detailed values locally. A simple table visual with totals would send two SQL queries, rather than one.

For more about composite model performance, you can refer this ariticle: High performing Power BI using Composite models with Aggregate feature 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.