What a stupid change: Edit Queries button is gone!

[Anonymous]

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.

[mhope]

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!

[edcarden]

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.

[Markzolotoy]

@tpoltorak Yes, I found it too, and it took me more than an hour.

[mducrocq68]

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.

[Markzolotoy]

@Greg_Deckler And where do I go after Transform data to get to my query to modify SQL code?

[chuckwheelis]

Thanks for posting this!  I was like "am I forgetting something?".   Good grief!

[Greg_Deckler · Accepted solution]

Home tab, Transform Data.

[mducrocq68]

Transform Data is nota available for me in 365 😫

[Anonymous]

They must be jerks at Microsoft...