Forum Discussion
ExportTo PowerBI - Api ExportTo
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"
}
]
}
}
I try with one table and column that no have space, but not works
In querystring in url on power bi works
"reportLevelFilters": [
{
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Operatori",
"column": "Operatore"
},
"operator": "Equals",
"values": ["asd"]
}
]
DavideBono97 the API does NOT work with this schema
"$schema": "http://powerbi.com/product/schema#basic",
No need for any schema, see the example I've shared which is working good. No schema in, and NO json object for the filter.
I try with this and works!
Good, **bleep** spaces
{
"filter": "Calendario_x0020_documento/Documento_x0020__x002D__x0020_Anni_x0020_trascorsi_x0020_da_x0020_ultimo_x0020_reload eq 1"
}Thanks a lot of both of you