Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it better for performance to combine steps?
Let's say, is below better for performance than the separate steps usually created when going trough the UI?
= Table.SelectColumns(Excel.Workbook(Source{[Name="ExcelFile.xlsx"]}[Content]){[Item="ExcelTable",Kind="Table"]}[Data], {"Column1", "Column2", "Column3", "Column4", "Column5"})
Of course, it lacks readability, but after having designed something, would it be good practice to combine some steps?
Is my assumption correct, that with each new step a 'new reality' is loaded correct? And thus with reducing steps it would increase performance?
Solved! Go to Solution.
No, the mode of loading each step only occurs in query editor design mode.
However, depending on what your datasource is, it may be better to mizimize the number of tables you load directly into the model, and use DAX to create additional tables as needed to do filtering on.
No it doesn't. The only thing to be aware of is whether you are putting your query folding actions at the correct position in the flow.
Combining steps also makes maintenance harder. We wrote an article on some recommendations to make your M code more maintainable. You can see it here: https://marqueeinsights.com/tip-how-to-make-your-power-query-m-code-self-documenting/
I hope this helps!
--Treb
No it doesn't. The only thing to be aware of is whether you are putting your query folding actions at the correct position in the flow.
Combining steps also makes maintenance harder. We wrote an article on some recommendations to make your M code more maintainable. You can see it here: https://marqueeinsights.com/tip-how-to-make-your-power-query-m-code-self-documenting/
I hope this helps!
--Treb
Is there a good way to determine if a query is folding (assuming you aren't using a datasource that supports View Native Query)? The only method I have found so far is by adding a step: Value.Metadata(PreviousStep)[QueryFolding]
The issue I have is that it is grayed out from the start, but query folding is happening.
This happens with the Azure Data Explorer data source. Also, if anyone knows how to update a connector to show the "View Native Query" let me know.
No, the mode of loading each step only occurs in query editor design mode.
However, depending on what your datasource is, it may be better to mizimize the number of tables you load directly into the model, and use DAX to create additional tables as needed to do filtering on.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.