Forum Discussion
Power BI - Performance - AAS / Measure
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
1 Reply
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-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567
https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fast-and/td-p/712871
