cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gjames
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

 

Geraint

2 REPLIES 2
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.

 51.PNG

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:

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.
Gjames
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,

 

GeraintpowerQueryFlowConnectorError.png

Helpful resources

Announcements
firstImage

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.

firstImage

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

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

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