Great Explanation! I love your channel! Please make a video on DAX Studio & Tabular Editor [External Tools] if possible. Also, how to implement page level security [Page 1 is visible to x number of people, page 2 is visible to y number of people].
Subscribed... Excellent explanation. It would be great if you can create content which helps in completing PL 300, let me know if you provide any paid courses in PL 300 and Data analytics.
I understood everything but i have doubt that after the transformation do we have to copy that native query code and paste it in sql? Then after we use that code in powerbi while importing the data source?
Thanks, ill look into it on why folding is not happening. My guess is that mquery engine is not completely updated to accommodate all functions in all database systems. Microsoft might have implemented this for selected functions from each database systems.
I asked ChatGPT, “Is there a mode that does not support query folding?” Response: Yes, there is a mode in Power BI where query folding is not applicable: Import Mode. In Import Mode, data is loaded from the data source into the Power BI model, and all transformations are applied within the Power Query Editor before the data is loaded. Since the data is already loaded into the Power BI model, there is no need for query folding because there are no queries being sent back to the data source during report interactions. However, when discussing Dual Storage (composite models), it's important to note that the model can contain both imported data and DirectQuery-connected tables. For the imported data (i.e., tables loaded in Import Mode), query folding occurs during the data loading process within the Power Query Editor before the data is loaded into the model. For DirectQuery-connected tables, Power BI attempts to fold supported transformations back to the data source, leveraging the query engine of the data source.
Clearly explained. Thank you.
You are welcome!
Really great explanation
Glad you liked it. Thanks!
one of the best channel to learn power bi concepts
Thanks for the appreciation buddy!
I Finally understood query folding in detail. Thank you!
You are welcome!
My goodness…you’re a champ❤…such detailed information…great😮
Glad you liked it!!
Very well explained. Thanks
Glad you liked it
Great Explanation! I love your channel! Please make a video on DAX Studio & Tabular Editor [External Tools] if possible.
Also, how to implement page level security [Page 1 is visible to x number of people, page 2 is visible to y number of people].
Great suggestion! Noted. Thanks..👍
Thank you. An excellent explanation.
Glad you enjoyed it!
Bloody great!!, subscribed to this channel. As a comment: It would be great if you create a guide like this for the "Incremental Refresh Process"
Thanks for the suggestion, I will make a note of this. Cheers!
Subscribed... Excellent explanation. It would be great if you can create content which helps in completing PL 300, let me know if you provide any paid courses in PL 300 and Data analytics.
Sure I will. Thanks for the sub, cheers !
I understood everything but i have doubt that after the transformation do we have to copy that native query code and paste it in sql? Then after we use that code in powerbi while importing the data source?
Hi, Everything will be done by the power query engine, you don't have to go to the sql database.
Top! Thank youuu
You're welcome!
i think there is a reverse function in postgresql.
Thanks, ill look into it on why folding is not happening. My guess is that mquery engine is not completely updated to accommodate all functions in all database systems. Microsoft might have implemented this for selected functions from each database systems.
I asked ChatGPT, “Is there a mode that does not support query folding?” Response:
Yes, there is a mode in Power BI where query folding is not applicable: Import Mode.
In Import Mode, data is loaded from the data source into the Power BI model, and all transformations are applied within the Power Query Editor before the data is loaded. Since the data is already loaded into the Power BI model, there is no need for query folding because there are no queries being sent back to the data source during report interactions.
However, when discussing Dual Storage (composite models), it's important to note that the model can contain both imported data and DirectQuery-connected tables. For the imported data (i.e., tables loaded in Import Mode), query folding occurs during the data loading process within the Power Query Editor before the data is loaded into the model. For DirectQuery-connected tables, Power BI attempts to fold supported transformations back to the data source, leveraging the query engine of the data source.
👍