DAX Fridays! #126: Understand the Formula Engine and Storage Engine to optimize your DAX queries

To be able to optimize DAX queries, you need to know how the formula engine and the storage engine work with them, so how about we let them explain themselves?
#curbal #powerbi #dax #DAXFridays

Hope you enjoy the video, i had fun doing it :)

Have you missed the Vertipaq series? Here are the videos:

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #dax #powerbi #mvp

[debzguha]

Such an amazingly human centred explanation! Thanks Ruth
Debz

[JonathanDtz]

Great video! I've been struggling with my DAX optimizations, and I've started using DAX studio to try and debug. This video does explain, in a very charismatic way, how to better understand my Server Timing stats. Thanks a lot!

[lorenzobreda]

I just watched a few of your videos, and I think you are simply fantastic!!😂😂😂

[ramonillarramendi]

Excelente!! Mil gracias por el video y por ponerlo todo como siempre tan sencillo. Además.. que risa las caras. Mil gracias!!

[andrecavasotero]

Of all the explanations I saw about FE and SE, that was the funniest.

[soymb]

Very useful information in this video. It makes me think a lot about how the formulas were done into the models. Thank you.

PD. I don't know what you did, but now your videos sound louder. Thank you.

[joseagundis]

Bonito video Ruth, que creatividad para dar un tema.

[jimmyni]

Hahahah! Very very very Love it! The simpler is the best! This is your way and helps a lot!

[barttrudeau]

That was hysterical 😂. I'm not usually laughing while learning. I think this may be my favorite video so far. And actually, I never did understand why the sqlbi guys are always making a fuss over storage engine and formula engine. Makes sense now - thanks!

[CloudhoundCoUk]

Like the disguises. Certainly catches the eye. Excellent video.

[ExplorandoDatos]

And the OSCAR goes to.... RUTH & RUTH!

[elrevesyelderecho]

Thanks.. Funny and easy to understand.

[nghuwei]

Does that means that my pbi desktop query will run faster if I have more threads on my CPU? I find that pbi desktop takes some time whenever I click on create measure. It is not instant. I have many measures in my report

[rrrprogram]

Long Was busy is learning R.... Hope u r doing good

[juanignacioparedes]

Nice video Ruth ! I laughed my ass of jajajaja

[bcippitelli]

hahaha! I loved it Funny and usefull! thanks for doing this video!!!

[AHMEDALDAFAAE]

Nice explanation.... Involving FE in every SE operation is called CallBack operation and it is very bad practice. So it is better to push the evaluation toward SE and make FE at the end of the Query Plan

[Bigsarl]

Double Like for the Twin Ruth 💛💛
Naji K.

[yekhtiari]

They seemed to be rivals not friends lol