You’re offline. This is a read only version of the page.
22
Hi all - Novice user here but have really enjoyed using the "Transform Data Using Power Query" action within Power Automate. That was until the new Power Automate UI updated...
In the past, I was able to establish a connection to my on-prem database via a personal gateway, make the connection, open the online Power Query designer within the "Transform Data Using Power Query" connector and everything was perfect... it was Power Query online! It was great!
Now, when I go in to edit my flow, and select that particular action within the new UI, I see a query string filled with a bunch of M code but also a bunch of additional parameters.. most of which I'm unsure how to update for future queries that might ping a different data source...
Is this really the new experience for this connector? Am I missing something obvious? Is there a way to revert back to classic view? If not, any tips on constructing that M code? I initially tried opening power bi desktop, producing the m code for my desired query there and then just pasting it in the connector query argument but it wasn't liking that.. additional mashup connections occur as part of that final query string that I can't replicate in M code alone...
Thanks for helping me think/work through this!
I'm not sure if this has always been there.. or if it's a recent release/update, but you can now toggle between new and classic via this icon when in edit mode.
Also experiencing this limitation. Very frustrating that MS would roll out a new UI and make it the default with such critical functionality missing. (There are also major issues with the "Send an email (V2)" connector in the new designer.)
I created a post for the issue on the Ideas site, please upvote it:
https://ideas.powerapps.com/d365community/idea/bd001667-cd8e-ee11-a81c-6045bdb64d9f
In the meantime, I've installed a Chrome extension called URL Replacement that allows me to launch an edit browser tab via right-click and automatically replaces "v3=true" with "v3=false" in the URL, thereby opening the classic designer.
Development... that is sure to be a temporary workaround....
Changing your URL string while in canvas edit mode from "v3=true" to "v3=false" reverts me back to classic view!
https://make.powerautomate.com/environments/.....v3=true -->{URL}...v3=false
I'm not saying I'm proud of it.. and I'm still looking for a longer term solution for the query string issues noted above.. but if it helps you in a pinch, great!
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
