Direct Query with Merge - When is it executed?

Hi tctrout ,

Based on your description, I don't really recommend you to use this compound model with double direct query. It may have some security risks: the query sent to one data source can contain data values already retrieved from another data source.

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

Also for cpu usage, part of the reason depends on the complexity of the created measure (the measure takes up cpu computing time, not memory). Since it is a dq mode, powerbi connects directly to the data source and sends queries to the back-end data source every time the measure is used.

In addition you can use the performance analyzer to find out the performance of visual objects or dax publics and how much they consume resources.

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.