Forum Discussion
What a stupid change: Edit Queries button is gone!
I got updated ribbon: It took 1/2 h to find the Edit Queries Button which is gone. Stupid Microsoft! I found the function at last on the right panel with mouse second on the query table.
Home tab, Transform Data.
11 Replies
Thanks for posting this! I was like "am I forgetting something?". Good grief!
edcardenHelper I
ATTN Microsoft - a really great way to encourage people to stop trying to use your software is to keep changing it every month or so that way most guides/tutorials and info about your product is outdated. Giving away software free will over come but just so much of this kind of garbage.
- Greg_Deckler
Community Champion
Home tab, Transform Data.
Transform Data is nota available for me in 365 😫
MarkzolotoyImpactful Individual
Greg_Deckler And where do I go after Transform data to get to my query to modify SQL code?
- Markzolotoy
tpoltorak Yes, I found it too, and it took me more than an hour.
where did you find it, i found Transform but thats for transforming your document to webpage. In the Home tab I do not see Transform Data...anywere
- Markzolotoy
Will it show my query's SQL?
- tpoltorak
In Power Query Editor go to Query settings, in the Applied Steps section find Source and click on the gear next to it. This will open a window where you can edit your SQL.
It just took me an hour to find.
right? it totally made no sense, idk why would they remove such a feasible option just like that and make it more difficult to work with? extremely weird.
but thanks to this thread. kudos!
