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
Thanks for the update

With url filter it works

With this string with special characters because my table and columns have the space

 

&filter=Calendario_x0020_documento/Documento_x0020__x002D__x0020_Anni_x0020_trascorsi_x0020_da_x0020_ultimo_x0020_reload eq 1

 

But in Api I don't expect to write it this way

Could it be the fault of the spaces on the API too?

Thanks to both of you AmosHersch  v-sshirivolu 

 

AmosHersch's avatar
AmosHersch
Microsoft Employee
11 months ago

DavideBono97 did you try the same string with special characters in the API? It might be an issue with the spaces.