Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Since a couple of days, I have the problem that I can't edit queries from the applied steps, Query Settings section.
missing option to edit query in applied steps (the gear icon)
Does anyone know why this happens?
See this image: https://i.imgur.com/sBoNFOd.png
Hi @MiltonDouglas ,
The only reason individual steps would not show from handwritten code is that you are not actually writing the parts of your query as valid individual steps. You've either successfully written a single step with multiple functioning parts, or you've written nonfunctional code. To give any detailed help beyond that would require actually seeing the query code in question.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
When I create a new source, the code is set as follows:
= SapHana.Database("XX.XXX.XX.XX:30015", [Query="SELECT ....
In this way, I can edit the query in the applied steps.
But, when I edit the query, the code generate by Power BI change to:
= Value.NativeQuery(SapHana.Database("XX.XXX.XX.XX:30015", [Implementation="2.0"]), "SELECT.....
@MiltonDouglas , Gear icon is only appear when it will open a popup ( Like formula window)
I think the question (and mine as well) is why that gear icon relating to a popup do appear next to so query steps and not next to others,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |