CODEWITHSUNDEEP
pythonpowerbipowerbi-paginated-reportspowerbi-api
Chris B
Chris B

Reputation: 3

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

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 []

Upvotes: 0

Views: 25

Answers (1)

Sam Nseir
Sam Nseir

Reputation: 12061

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

Upvotes: 0

Related Questions