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 try this solution but not works

This is true name of column and table

The value is numeric

I try with Equal operator but not works

It is possible the error is for the space on the column and table ?

Thanks and sorry

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

Hi DavideBono97 ,
Thank you for the update. 

This error can occur if there are spaces or special characters in your table or column names, or if the names do not exactly match those in the dataset schema. Please verify that you are using the original field names from the dataset, rather than any renamed fields from the report. For columns with spaces or hyphens, ensure the spelling matches the dataset precisely.