Unanswered

Passing dynamic parameters while exporting file from Paginated report

(0) Share

Report

Posted on by a9kita

I am building a flow to export pdf from paginated report that has 6 Parameters. I have successfully built a logic using Power BI dataset to help me get these parameter values but i am struggling to pass them to the 'Export to file for Paginated report' action.

I get 4 unique rows from the power bi dataset, with 6 columns, which means i want 4 pdf files to be exported with the parameters coming from those 6 columns .
Here is the schema of Parse Json step:

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "RefreshParameters[P1]": {
 "type": "string"
 },
 "RefreshParameters[P2]": {
 "type": "string"
 },
 "RefreshParameters[P3]": {
 "type": "string"
 },
 "RefreshParameters[P4]": {
 "type": "string"
 },
 "RefreshParameters[P5]": {
 "type": "string"
 },
 "RefreshParameters[P6]": {
 "type": "string"
 }
 },
 "required": [
 "RefreshParameters[P1]",
 "RefreshParameters[P2]",
 "RefreshParameters[P3]",
 "RefreshParameters[P4]",
 "RefreshParameters[P5]",
 "RefreshParameters[P6]"
 ]
 }
}

Looping though this array to give single values for my parameters to export action is quite a task. And Power automate is adding in many additional loops.

What would be the best way to get parameter values of 6 fields from the output of power bi dataset.
@ManishSolanki @Expiscornovus @creativeopinion

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @a9kita

How will you pass the result of array in paginated report as parameter? Pls give an example with input array & output required for parameters. The reason for asking is I am a beginner in Power BI 😀

Was this reply helpful? Yes No
a9kita 8 on at

Like (0)

Report
I was expecting this question. Here's my Power BI table, each row represents the parameters I need for 1 file, 4 rows= 4 files.
when i parse it as Json, here's my format:

[ { "[Entity]": "XYZ", "[RunType]": "Ad-hoc", "[ProcessRunDate]": "05-16-2024 (06:13 AM ET)", "[Reporting Date]": "2024-04-30T00:00:00 }, { "[Entity]": "UVW", "[Run Type]": "Ad-hoc", "[Process Run Date]": "05-16-2024 (06:13 AM ET)", "and so on" } ]

The 'file export' Action is supposed be in a loop, to iterate through each of the 4 rows. And the parameter fields are passed in the form of name - value pairs.
Here is an example when I pass the values manually
on checking the test results, I see it formats the input in below format

Was this reply helpful? Yes No
a9kita 8 on at

Like (0)

Report

@ManishSolanki So the task is to pass these manual values dynamically.
Thanks for considering!

Was this reply helpful? Yes No
a9kita 8 on at

Like (1)

Report

Seems like I was over complicating the flow by adding unnecessary loops. Also, I deleted the extra loops added by default. The flow works perfectly with single loop. 🙂

Was this reply helpful? Yes No