Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Transform data using Power query - Create Query error using Data Gateway

I'm having trouble with the SQL server 'Transform data using Power Query' action using our Data Gateway connection. I can add it to my flow, but I get the following error after I click 'Create query':


An exception occured: One or more errors occurred. (Session ID: b2f918596f0547dd9821c0c296b338b6)


We've updated the Data Gateway to the latest version (3000.0.155.1) and I've created a new connection, but I'm still getting the same error this morning (15/11).


Any help would be much appreciated



Community Support Team
Community Support Team

Re: Transform data using Power query - Create Query error using Data Gateway

Hi @Gjames,


I did a test on my side, although I also encountered an error, but does not affect the subsequent operations, the Power query interface can be opened normally.


Could you share a screenshot of the error message interface?

You could try to use this action in a good network environment, because this is similar to live connection, and if there is no good network environment, the operation is very difficult.

For reference, my Flow login account and the account used by Gateway are the same mailbox. I don't know if this will be the cause of the error.

A few previous tests found that I could not search for an available Gateway without using the same account.

There is also Gateway used in the default environment, more about the configuration and use of Gateway, please refer to this link:


Best Regards,


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.
Level: Powered On

Re: Transform data using Power query - Create Query error using Data Gateway

Hi Barry,


Please see a screenshot attached. I can't get through to the power query interface unfortunately.


Kind regards,



Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020


Flow Community User Group Member Badge

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


Microsoft Learn

Learn how to build the business apps that you need


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 53 members 4,790 guests
Please welcome our newest community members: