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.
There used to be a way to merge all the applied steps in the advanced editor, so that it would only show up as the first step in query. But I can't seem to remember how to do it.
Any suggesetions?
Solved! Go to Solution.
@sigridr first step only
let
Source =
[step1 = 1,
step2 = 2,
stepx = step1 + step2][stepx]
in
Source
no step name at all, just a query name
[step1 = 1,
step2 = 2,
stepx = step1 + step2][stepx]
@sigridr first step only
let
Source =
[step1 = 1,
step2 = 2,
stepx = step1 + step2][stepx]
in
Source
no step name at all, just a query name
[step1 = 1,
step2 = 2,
stepx = step1 + step2][stepx]
Hi @sigridr ,
You can merge all the applied steps in the advanced editor by selecting the last step in your query, then holding down the Shift key and selecting the first step. This should highlight all the steps in between as well. Once you've selected all the steps, right-click and choose "Merge Queries". This will create a new query with all the steps merged into one. Then, to make this new query the first step in your original query, simply drag and drop it to the top of the Applied Steps pane.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sigridr ,
You can just put all your steps inside a variable using the advanced editor
let x =
applied steps...
in x
Proud to be a Super User!
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.