Basically query folding is used for performance optimization for which just copy the code of native query of the last applied step of the power query and simply paste it to the sql.....the sql will perform the similar transformation itself.
Hi Shashank. Can you or anybody can answer whether the Forage KPMG virtual internship for data analytics are anything worth of? And does completing it will be counted in our experience?
No , it means that “the transformation which can be done in Power-query can also be done the same work directly from the database itself in the Power-query platform
Ap normally power query me transformation steps karty hoo tw wo power query engine apne pass store karta h which takes time to load. Query folding= ap power query me steps karty hoo for example 2 columns ko merge kia h. But this instead of using power query engine. Wo directly database me hoti h. Which saves alot of time while loading and this is the best method. M code har step ko sql ki language me convert krta rehta h.
Basically query folding is used for performance optimization for which just copy the code of native query of the last applied step of the power query and simply paste it to the sql.....the sql will perform the similar transformation itself.
True.
Still I am not able to understand
Your way of explaining topic is so good n accurate plz maķe more vedios relted to power bi
Dax functions
Thank you, I will
up until watching your video, i didnt understand the reason for query folding...Thanks for the amazing explanation
Very nicely explained
Superb brooo ✌️✌️💪💪💪
Nice explanation
Good explanation 👏 👍
Thanx to Codebasics team for Recommending me this youtube channel
🔥🔥🔥
How to do it practically?
Plz make a list of important questions for freshers
Dax concept ki bhi video bana do sir
Great job ... Your classmate from 8th c LPS sect i
Hi Shashank.
Can you or anybody can answer whether the Forage KPMG virtual internship for data analytics are anything worth of?
And does completing it will be counted in our experience?
Does it really required?
How's the market of power bi in 2024
Hi bro, please let me know if you have any vacancies as a fresher.
Nice👍. Sir why as entry level data analyst jobs are not available in market?
Because currently market is growing through lot of up and downs
So it means if we transform the data in power queery it will change in source as well?
No
No , it means that “the transformation which can be done in Power-query can also be done the same work directly from the database itself in the Power-query platform
samajh nhi aaya little confusing
Ap normally power query me transformation steps karty hoo tw wo power query engine apne pass store karta h which takes time to load.
Query folding= ap power query me steps karty hoo for example 2 columns ko merge kia h. But this instead of using power query engine. Wo directly database me hoti h. Which saves alot of time while loading and this is the best method.
M code har step ko sql ki language me convert krta rehta h.