Unanswered

Run a query against a Power BI dataset and insert in to SQL Database

(0) Share

Report

Posted on by therush321

Hi All

I am trying to fetch the field names to insert into my Azure SQL database but cannot get to that stage. All I get is the output and not the names of the fields I require.

Please see the image for my flow.

Thanks in advance.

Categories:

Building flows

Run a query again...

I have the same question (0)

All responses (6)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @therush321

Pls share the screenshot of the previous flow run, I want to see the result from each action especially output of "Run query against a dataset" and "Select" actions.

Thanks

Was this reply helpful? Yes No
therush321 on at

Like (0)

Report
@ManishSolanki
The out of the Run a query against a dataset:

{ "statusCode": 200, "headers": { "Pragma": "no-cache", "Transfer-Encoding": "chunked", "Strict-Transport-Security": "max-age=31536000; includeSubDomains", "X-Frame-Options": "deny", "X-Content-Type-Options": "nosniff", "RequestId": "2785bd69-4133-9c35-6f519dff77de", "Access-Control-Expose-Headers": "RequestId", "Timing-Allow-Origin": "*", "x-ms-apihub-cached-response": "false", "x-ms-apihub-obo": "false", "Cache-Control": "no-store, must-revalidate, no-cache", "Date": "Wed, 16 Aug 2023 13:33:17 GMT", "Content-Type": "application/json", "Content-Length": "246742" }, "body": { "results": [ { "tables": [ { "rows": [ { "[IsGrandTotalRowTotal]": true, "[SumBillable_Hours]": 78840331.3858350001, "[SumTotal_Hours]": 9407717.5886129998, "[AverageUtilisation__]": 0.788890974963097, "[SumLeave_Unaffected_by_UT]": 95980.5 }, { "Date[MMM-YYYY]": "Aug-2022", "Date[MonthYrSort]": 202208, "User[Staff Name]": "Test User", "Department[Practice]": "GOP", "[IsGrandTotalRowTotal]": false, "[SumBillable_Hours]": 165, "[SumTotal_Hours]": 184, "[AverageUtilisation__]": 0.9375

Output of the Select action:

[ { "Month_Year": null, "Staff_Name": null }, { "Month_Year": "Aug-2022", "Staff_Name": "Test User"

Was this reply helpful? Yes No
Verified answer

therush321 on at

Like (2)

Report
I managed to use the Parse JSON action and it worked.

Had to adjust the apply to each code with the expression below:

body('Parse_JSON')?['firstTableRows']

Was this reply helpful? Yes No
sujatarao 8 on at

Like (0)

Report

Hi Could you please show me what you have written inside insert statement.

Was this reply helpful? Yes No
therush321 on at

Like (0)

Report

@sujatarao I just selected the fields needed to insert a row into my SQL table, mapping the fields from my parse JSON statement at the top. So no SQL code is written here.

Was this reply helpful? Yes No
sujatarao 8 on at

Like (0)

Report
@therush321 I am trying to insert output from json file into azure sql db , but it seems
body('Parse_JSON')?['firstTableRows']
is not working in apply to each step .

attaching my workflow here: till parse its working fine, I am stuck after that step

Was this reply helpful? Yes No