Iterate through results of a Power Bi dataset query

Like (0) Share

Report

Posted on 10 Jan 2023 14:09:42 by Community Power Pla...

I am building a flow that will query a Power Bi Dataset, and process each record (to send an email with the record's content).

I have built a similar flow that reads a SharePoint list, but apparently a query against a Power Bi Dataset is a different animal.

I have a For Each after the query. The For Each step seems to recognize that the input is from a PBI dataset query because when selecting an output, it shows "First Table Rows" along with some other options (See attached pic). In the following email, when clicking in the body and showing the Dynamic values, the only option that appears, "Current Item".

So at this point what I need are links to examples or documentation on the data structures and flow steps required to step through the query results.

Thanks

ApplyToEach.PNG

currentItem.PNG

All responses (1)

Answers (1)

Verified answer

Community Power Pla... on 20 Jan 2023 at 19:44:58

Like (0)

Report

Re: Iterate through results of a Power Bi dataset query

Here is another approach.

Here is a summary of the problem:
Summary:
The workflow produces two JSON datasets containing the results of a query.
If I use the result from the query, I do not have access to the individual fields in the data set.
If I use the result from the Parse JSON, I get an error message indicating that the result is null.

The solution was to ditch the Parse JSON step, use First Table Rows to drive the Apply to Each, and then perform a Compose Action using the Current item. That exposed the individual columns of the data is the key to the solution.