I have just started using Advanced Query Editor.
When i make a small change and hit done I can still see the applied steps in the right hand Query Settings Panel.
However if I make a cut and paste/major chnage in teh editor and hit done a single Applied Step is shown renamed after the Query.
How do I restore the step by step view or is somethign more significant happening?
Hi @ianhan13 ,
Has your problem been solved? Please post your M code in text form and I will test it. Please also replace sensitive information.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry no point in me sending the code since it is in a shambles. Thank you for explaining why the query steps do not appear and I will commence form scratch repasting line by line until the matter is reosolved
Would still aprreciate an explantion of the purpose of the final line of code after 'In'.
Hi @ianhan13 , take a look at this documentation here:
The step after "In" is what is used as the final result set. Generally, this is the same as the name of the last setp. From squinting at the screenshot you provided, it looks like you could have a typo in that portion.
@ianhan13 you need to paste the code not the image, how you expect someone to understand and debug that tiny image? Help the community to get help, post your questions/replies carefully.
Read this post to get your answer quickly.
ok many apologies - the image was simply to show the code has no syntax errors and the problem is with the naming convention I am using. I did not want to waste people's valuable time with my poor naming discipline but rather to learn how to get a meaningful display back to debug the issue. Here is code:
Thanks so if the code is messed up it won't display the steps in the side panel.
My challenge is the code syntax is ok but i have misnamed table columns when renaming but the only way I know to see the columns names to correct this is via the step by step view?
Also what is the purpose of the text at the very end after the 'in statment in my case a tabed in text of #"filtered Rows3"
@ianhan13 is the query still actually executing successfully? Can you post a screenshot and/or code?
My initial guess is that you've accidentally deleted or overwritten part of the necessary syntax when copy/pasting.
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.