Unanswered

Power Automate: 'SqlGetPassThroughPQMetadata' failed with status code 'BadRequest'

(0) Share

Report

Posted on by Eric_Huang

Background: I have connectted a SQL Server using SQL Server Authentication.

I want to build a automate flow while need to build a step SQL Server Transform data using power query. Choosing the SQL Server Connection and could query the correct data.

But I can't save this flow. Error shows as below:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sql' operation 'SqlGetPassThroughPQMetadata' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: {"resultType":"Exception","message":"Unsupported schema type 'string'.","details":null,"errors":[],"evaluationUsage":null}'.

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Eric_Huang ,

Which step caused the flow to fail to save?

Could you provide some screenshots?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Eric_Huang 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky,
Firstly thank you for your attention.
I meet the error just in creating the flow. when I click the saving flow, it shows that error.
scrrenshots as below:

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Eric_Huang ,

Are you using azure sql or Sql sever (on-premises)?

The document states that the action cannot be used in azure sql.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Eric_Huang 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky,
Our admin told me we are using SQL on-premise not Azure.
Please noted. Thanks!

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Eric_Huang ,

Sorry no idea.

I can save flow on my side.

Please check your connection and your power query detail.

Besides, I suggest you submit a support ticket.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Eric_Huang 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky,
Well, thank you all the same.
My connect is fine and Query could get correct result.
I will raise a support a ticket.

Was this reply helpful? Yes No
Trys 18 on at

Like (0)

Report
Copy link

Link copied!

Hi @Eric_Huang, did you find a solution? I am receiving the same error trying to save a flow with a Power Query task. The connection and Power Query task are working and I am getting a result.

Was this reply helpful? Yes No
Trys 18 on at

Like (0)

Report
Copy link

Link copied!

I just found a solution - my query was doing a Count Values operation. I had to convert the result to a table, then I could save it without the above error.

Was this reply helpful? Yes No