it executes the query twice with an indicator filter

[Cobra77]

Hi

We have a table with more than 160 indicators.
and on we have a filter on the visual, based on an indicator.

it takes time to respond, and we found that removing the filter was much faster.

With the performance analyzer we noticed that it executes the request twice : 

Any idea or trick to get around this ?
Thanks for your help.

[v-yiruan-msft · Accepted solution]

Hi @Cobra77 ，

You can check this official documentation below for more insights and explanations on why the query runs multiple times. Here is one idea about stoping executing queries multiple times shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature.

Why does my query run multiple times?

And you can consider to optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.

Optimization guide for Power BI

Power BI Performance Tips and Techniques

A comprehensive guide to Power BI performance tuning

Testing Performance Of Power BI Reports In The Browser

Best Regards