Unanswered

Transform Data Using Power Query in New UI

(1) Share

Report

Posted on by mstearns

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!

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

mstearns 22 on at

Like (3)

Report

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!

Was this reply helpful? Yes No
laidlawl 31 on at

Like (0)

Report

Same issue here, thanks for getting this posted. Glad I'm not alone in thinking this action is currently unusable in the new UI

Was this reply helpful? Yes No
StoneCoastChuck 11 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
mstearns 22 on at

Like (0)

Report

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.

PA Toggle View.png

Was this reply helpful? Yes No