Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Finnair
Advocate I
Advocate I

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Home tab, Transform Data.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

11 REPLIES 11
mhope
New Member

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
Helper I
Helper 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.

Markzolotoy
Impactful Individual
Impactful Individual

@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
Impactful Individual
Impactful Individual

Will it show my query's SQL?

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
Impactful Individual
Impactful Individual

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

chuckwheelis
New Member

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

Greg_Deckler
Super User
Super User

Home tab, Transform Data.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Transform Data is nota available for me in 365 😫

They must be jerks at Microsoft...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.