6 Comments
- Ben_SacherichNew Member
I agree with this feature request and am surprised it doesn't exist already. Here's my similar write up of the request:
When using the Power Query editor I would like to see an additional option in the Steps right-click menu to allow me to Comment or Uncomment a step. When debugging I often create filters and I'd like to be able to easily turn them on or off. Commenting a step would use the same logic as your Delete command by updating any referencing steps to refer to the step above, but instead of removing the step it would prefix it with //.
You could make the prefix include another character like "//!" so it could discern between commented steps and regular comments. Commented steps with the special prefix could still show in the Steps panel but with distinct formatting (green font, italics, etc.). The developer could right-click on a commented step to restore it. The assumption would have to be that any references to the step above would now point to the restored step.
Vote for this if you think it would save you time troubleshooting your queries.
- jefferydeckerNew Member
Vital suggestion, and this idea is suggested many, many times. The votes should be combined.
- jefferydeckerNew Member
Oh yes, and further, the GUI should preserve all comments and white space choices. How absurd to have comment and formatting that I chose for readability purposes just wiped out. Documentation should be considered a much higher priority, including indent and spacing choices, especially in a language with such long statements. Thank you.
- fbcideas_migusrNew MemberStatus added:Needs Votes
- Jennifer7711
Advocate I
This is a great suggestion. Essentially, being able to toggle steps on/off in Power Query would enable modelers to not only debug queries - but to quickly manipulate them for ad hoc purposes while preserving established work. The example given to toggle filters on and off is a use case I run into constantly during semantic model tuning and validation. - Jennifer7711
Advocate I
See also: Enable\disable Power Query steps: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enable-disable-Power-Query-steps/idi-p/4451532
Recent ideas
Power BI Admin to Disable the New Ribbon Preview & Control Rep Toolbar Visibility at Tenant Level
Allow Power BI Administrators to Disable the New Ribbon Preview and Control Report Toolbar Visibility at Tenant Level It takes too much real estate and by default users with low maturity leaves it a...icassiem21 minutes agoPost ProdigyNew1View0likes0CommentsShow the column name and row when refresh fails with OLE DB error 0x80040E1D
When refreshing a table, I get "OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D." The message does not show which column or row caused the error. With a table that has many columns, it is ve...HTakashi32 minutes agoNew MemberNew1View0likes0Comments- axserv9 hours agoNew MemberPlanned9.2KViews145likes16Comments
Custom visuals: allow same-tab navigation & reduce confirm-navigation friction for trusted links
Description: Custom visuals (e.g. Deneb) that trigger navigation via href currently have two limitations that create friction for legitimate, author-controlled use cases: Links always open in a ne...AlexSenEON16 hours agoNew MemberNew16Views1like1Comment