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?
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.