Perf issue using multiple slider filters on multiple visuals

[_mk7]

Hello!

I have a report where we’re attempting to use two slider slicers to limit the results returned in multiple visuals. I’m achieving this by creating measures using the slider values as FILTER conditions, then applying a visual level filter on the visuals to filter out data where BLANK is returned.

This approach works on smaller datasets, however, when I’m going against full volume (~300M rows in fact table), I’m hitting per-query resource limit exceeded (Premium Capacity P1 SKU, 6GB default limit).

Here’s an earlier thread I posted describing the problem and including a smaller sample dataset.

Measure Perf - Exceeding per-query resource limit (P1)

Hey @AntrikshSharma @BrianJ , The measure you provided a while back to determine min sales dynamically (Determine the min of measure - #9 by EnterpriseDNA) works great, however, we’re running into volume that’s causing us to hit premium capacity per-query memory limits (P1 SKU, default limit equates to roughly 6144MB). More details: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. To …

Per @AntrikshSharma feedback, it looks like the problem lies in the usage of the measures within the filter pane. In addition, the Min Total Sales (ITEM) measure appears to be resource intensive.

Is there a recommended alternative approach for applying multiple slider filters to multiple visuals that would be less resource intensive?

[Keith]

Maybe you need to go directly to the Microsoft Power BI Team Support for this.

Could you have the data grouped together up streamed before going into power bi and filter on one filter instead of using multiple filters? (have your IT team do it)

Likely its just a lot of trail and error procedures that you need to do to figure it out what its faster.

Those are the steps I would try.

thanks
Keith

[EnterpriseDNA]

Hello @_mk7 , good to see that you are having progress with your inquiry. Did the response from @Keith help you solve your inquiry?

If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

[EnterpriseDNA]

Hi @_mk7, we’ve noticed that no response has been received from you since Sep 13.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

[EnterpriseDNA]

Hi @_mk7, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please create a new thread.