Forum Discussion

DavideBono97's avatar
DavideBono97
Helper I
11 months ago
Solved

ExportTo PowerBI - Api ExportTo

I'm using PowerBI's ExportTo API. The report filters seem to be ignored. I tried like this   https://api.powerbi.com/v1.0/myorg/groups/xxxx/reports/xxxx/ExportTo { "format": "PDF", "powerBIRe...
Need Help
  • AmosHersch's avatar
    AmosHersch
    11 months ago

    I did a test with spaces in the table name and column name:

    Table name:          ex1 renamed

    Column name:      Column three 

     

    This requeust body produced a filtered result:

     


    Reqused body:
    {
      "format": "PDF",
      "powerBIReportConfiguration": {
        "settings": {},
        "reportLevelFilters": [
          {
            "filter": "ex1_x0020_renamed/Column_x0020_three lt 0"
          }
        ]
      }
    }

DavideBono97's avatar
DavideBono97
Helper I
11 months ago

Hi

I don't have a problem with export-to operations, I already use these

My problem is the reportLevelFilters, this is ignored

I'm asking you if I'm using the wrong syntax

Thanks

v-sshirivolu's avatar
v-sshirivolu
Community Support
11 months ago

Hi DavideBono97 ,

The reason your filter is ignored is because reportLevelFilters does not accept plain strings.
You need to pass it in the official filter schema format, for example:

"reportLevelFilters": [
{
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Calendario documento",
"column": "Documento - Anni trascorsi da ultimo reload"
},
"operator": "LessThan",
"values": [5]
}
]

This way the filter will be applied correctly during ExportTo.

Ref: Power BI embedded analytics documentation - Power BI | Microsoft Learn