Search code examples
pythonpowerbipowerbi-paginated-reportspowerbi-api

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


Solution

  • 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