Forum Discussion

_power_bi's avatar
_power_bi
Helper I
2 years ago

Composite model issue

I am having an issue with a composite model.  Here is the setup:  a customers table, a customer_orders table, and an order details table. The first two are imported, the order details table is massiv...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi _power_bi ,

 

Is the problem occurring on the PBI desktop or the service? What version are you using?

 

Could you please show a screenshot of the performance analyzer? I would like to confirm if the performance issue is happening in the query preparation stage or in the visual rendering stage.

DirectQuery in Power BI - Performance diagnostics

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn

 

Also try increasing the maximum number of active connections, which can improve performance in some scenarios.

DirectQuery in Power BI - Power BI | Microsoft Learn

Evaluation configuration settings for Desktop - Power BI | Microsoft Learn

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

_power_bi's avatar
_power_bi
Helper I
2 years ago

My main issue is that this delay happens the first time and only the first time when drilling through. If I pick a different order number or simply repeat the drillthrough, it responds immediately.  The rest of the report is snappy and no delays. 

1st time:

 

2nd time: