Guidance on Improving FE Performance

AniketMS · ‎12-09-2023

Hi ,

I have a data model with 4 millions records each date and it is in Import mode.

IN dax we have implemented to 10 and others logic .

One of the dax is taking more than 30 seconds to run . post analysing it is identified that FE is taking 95% of the time . Please refer the screenshot below.

Looking forward to seek some guidance on the way / list of points that needs to be checked to improve the FE performance.

Thanks!

Fowmy · ‎12-10-2023

@AniketMS

DAX optimization is a broad area, just by looking at the timing you have shared it's not possible to identify and tell you what exactly causes the formula engine high usage it's important that I look at the measure, also if you have the data model details this will help. For the time being, please share your measure

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group