cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JeromePou
Level: Powered On

New power query transformation: gateway not found

Hi,

 

I'm testing the new power query transformation, but I got an error:

The connection requires a gateway

(for sure I have a working one )

I know its a preview feature, but any idea why I got this error?

8 REPLIES 8
Community Support Team
Community Support Team

Re: New power query transformation: gateway not found

Hi @JeromePou,

 

Please make sure that the version of your gateway is up to date, version could cause problems with your connection.

When configuring, please make sure to use the gateway in the default environment, and choose the one that is expected. Check if it is a normal connection.

Check the port and firewall settings to determine if these limits the use of the gateway. For related documentation, please refer to: https://docs.microsoft.com/en-us/flow/gateway-reference

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JeromePou
Level: Powered On

Re: New power query transformation: gateway not found

Hi,

 

I have 2 gateways in cluster mode 1 was updated this week, the second has to be updated but was updated last month. so not so late in the releases.

is it supported with the very latest version only?

 

Community Support Team
Community Support Team

Re: New power query transformation: gateway not found

Hi @JeromePou,

 

I have tested on my side, I updated the version of the gateway to the latest, configured it according to the requirements, and there was the same problem as you.

Maybe this feature is not fully prepared, I will continue to follow up on this issue and feed back to the product team. If there are any updates, I will post back here.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JeromePou
Level: Powered On

Re: New power query transformation: gateway not found

I suffering issue with the gateway in powerapps too.

but not all the environments.

so some env. are working, other are not working.

in microsoft flows the power query is not working at all while the SQL Server get rows task is working.

 

so not a stable behavior for now.

MichelH
Level 8

Re: New power query transformation: gateway not found

I'm also very much interested geting this to work.

I hope I now get notified if this thread is updated.

EdHans
Level 8

Re: New power query transformation: gateway not found

I have the latest gateways installed as well, as part of a gateway cluster. The connections work fine in Power BI and Power Apps. Also works in Flow when I select the table in the Trigger setting, but when I go to Actions, it says the connection needs a gateway, so something seems broken here. My gateway below shows Flow is working configured properly, as I assumed since I can read and select the tables in our SQL server.

 

ScreenClip.png

Anonymous
Not applicable

Re: New power query transformation: gateway not found

Hello Jerome, I also have this problem. An admin confirmed that this is a bug and the MS Team is fixing it.

Gjames
Level: Powered On

Re: New power query transformation: gateway not found

Thanks Horacio, hopefully we'll get the fix for this soon

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,614)