How to structure input to use PowerBI REST API: multi-value parameters

Question

I have tried an array, comma delimited list, and just about everything else to send multiple values to a single parameter. note: the paginated report is published and working. you select 1 to 180 values for Param3 and the report returns a multi page report with a page for each param3 value.

body = { "format": "PDF", "paginatedReportConfiguration": { "parameterValues": [ {"name": "Param1", "value": "Value1"}, {"name": "Param2", "value": "Value2"}, {"name": "Date", "value": "05/20/2013"}, { "name": "MultiValParam3", # Single string with embedded quotes around each item: "value": how do i need to structure the data for a multi value parameter that runs a paginated report based on each value? } ] } }

i have tried:

""Value1", "Value2""

["Value1", "Value2"]

"Value1","Value2"

so many things and everything comes back with values not valid as Value1, Value2 or as not valid because []

Sam Nseir · Accepted Answer · 2025-01-25 22:42:20Z

0

Like so:

{
  "format": "PDF",
  "paginatedReportConfiguration":{
    "parameterValues":[
      {"name": "State", "value": "WA"},
      {"name": "City", "value": "Seattle"},
      {"name": "City", "value": "Bellevue"},
      {"name": "City", "value": "Redmond"}
    ]
  }
}

See: Report parameters

answered Jan 25 at 22:42

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chris B Jan 26 at 23:39

Amazing. Worked. I have a simple function I ended up using to loop through all values from a stored proc

Collectives™ on Stack Overflow

How to structure input to use PowerBI REST API: multi-value parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related