Power BI - Performance - AAS / Measure

[Zerpmi]

Hello,

I have a question about performance regarding:

• Measure in PBIX using data from AAS vs Measure in AAS

We are trying to solve some slow tables in our Power BI report. Already tried optimizing the DAX formula.

I'm doubting if it makes any different to move all my measures to AAS. Can anyone clear this up for me?

Would appreciate it alot.

Best regards,

Zerpmi

[amitchandak]

@Zerpmi , 1. Remove any bi-directional join

2. Avoid measure nested more than 2 level

3. Avoid the use of iserror, isfiltered , hasonevalue, unless most needed

Share the measure working slow with dependent measures

refer

Best Practices
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Rel...
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...
https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...