Unanswered

Not seeing "First Table Rows" when using Run a query against

(2) Share

Report

Posted on by DE-21082103-0

I am using the Run Query Against a Dataset action and it's working successfully. However, I need to get the schema for it for the next action, Parse JSON. When I click to get the Output, "Frist Table Rows" isn't under Outputs. It shows statusCode, headers, body and then goes to properties. Not sure what I am doing wrong? When I copy the data from body and paste it, I get multiple arrays which is creating multiple "for each". Any guidance would be appreciated.

Categories:

Building flows

Screenshot 2024-0...

I have the same question (2)

All responses (7)

Answers (0)

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (0)

Report

HI,

You really need to share what you are doing, versus trying to explain.

I have no idea what you are doing that causes lots of Apply to Eachs.

I under WHY there are based on the JSON, but why are you triggering them, versus going directly to the Table/Rows you need and only pulling those.

Please share your actions and what you want to do, so we can help.

Was this reply helpful? Yes No
DE-21082103-0 6 on at

Like (0)

Report

Thanks for the reply.

My ultimate goal is to use Power Automate to update a Sharepoint List with data from a Power BI report. So I have a Power BI report in a workspace. I click Performance Analyzer and Start recording to get the DAX query from the visual.

In Power Automate I am using the manual trigger (for now) to start the flow. I chose the "Run a query against a dataset" action and selected the workspace and data set. I pasted in the DAX query and I ran the flow. It succeeded.

I now need to get the schema from the query action. I go to the Run History and select it and click the "Run a query against a dataset" action. According to everything I've read (and watched) I am supposed to see "First Table Rows" under the Outputs section. I do not. Instead, under Outputs, I see "statusCode", "headers", "body".

The next step is to add the "Data Operation" action and put the schema from "First Table Rows" in the Parse JSON section. Since I didn't get what I was expecting, I tried putting in the text from the "body" section of the query action. but it's not giving me the expected results.

Thanks again for your reply.

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

Run a simpler DAX query, one where you know it actually returns data.

"However, I need to get the schema for it for the next action, "

Not really. Usually you should know your data and not need a schema.

Was this reply helpful? Yes No
CU21100340-0 3 on at

Like (0)

Report

hi, did you get a solution for this? I'm having the same issue. thanks so much for raising.

Was this reply helpful? Yes No
MK-06031457-0 4 on at

Like (0)

Report

Hi any solutions found for this issue?

I am also facing the same issue

Was this reply helpful? Yes No
HB-01040615-0 2 on at

Like (1)

Report

Hi,

I had the same problem, and found a workaround by disabling the "new designer" in the upper right corner, see attached screenshot.

Was this reply helpful? Yes No
MK-06031457-0 4 on at

Like (0)

Report

Thank you HB-01040615-0 this helped

Was this reply helpful? Yes No