Power Platform Community Forum Thread Details

i'm trying to use the Transform SQL using Power Query action. i've got several flows with it working fine on one SQL database. But i am doing similar on another SQL db that i have a connector for. Note i'm an admin, full credentials and this db is already part of my gateway.

I can access the data and transform it using the transform SQL power query action just fine, but when it runs it fails with

{

"resultType": "Exception",

"message": "The key didn't match any rows in the table.",

"errors": []

}

and the SELECT i have next says "BadRequest. The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array." and "INPUTS from null"

looking on the web it seems to imply a permissions issue but (1) i am full admin with access, (2) it works fine through powerquery in Excel, (3) the db and table are all accessable via the gateway...

so i'm stuck. Any advice would be most welcome.

thanks

Stephen

Categories:

Building flows