Slicers speed/ online report speed

[Anonymous]

Hi guys,

I have problem with slicers performance (date slicer) on Power BI online and I don't know where to start to have biggest impact.

Cache is already turned on, perf. analyzer told me just about perf. of main table. Filters/ slicers are already based on dim tables.

the main report page is basically 2 tables, sliced separately about customer journey from lead to install by lead source
which means that it takes information from leads, costs, CRM, delivery fact tables
and as there are multiple views in other tabs, I don't believe I can reduce granularity of those tables, and I shouldn't if we want to keep good practices of sharing dataset for multiple reports.

I spoke with IT dep. about increasing capacity and they told me that next level costs additional 5k eur/ month.

I was thinking about pre-calculating some of those measures on our server (# of leads/ day/ (source like google, facebook...) but I guess we can agree that it is not scalable if there will be need for new dimension and there will be.

Any advice will be appreciated.

[amitchandak]

@Anonymous , Is it a direct query or Import model. If it is import model Is slicer coming from a Fact or dimension.

A slicer from dimension would always be faster. Slicer form a table having bidirectional joins would slow.

refer

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices

[Anonymous]

Its import model, 

Slicer from dimension, quite standard "Date table"

bidirectional joins are big no in my data model, so that isn't a problem.

Thanks for the links, I will check them.

[v-deddai1-msft]

Hi @Anonymous ,

You can also use  Power BI Premium Metrics app to determine if the report-hosting capacity frequently exceeds capacity resources. 

Please refer to  https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot

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

Best Regards,

Dedmon Dai

[Anonymous]

I would need to be capacity admin for that, so seems like I can only speak with him, to find the problems for me instead.

[v-deddai1-msft]

Hi @Anonymous ，

Yes, you need admin permission to troubleshot the issue.

Best Regards,

Dedmon Dai