Forum Discussion
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...
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"
}
]
}
}
DavideBono97did you try applying the same filter string in Power BI web portal through the URL as explained here Filter a report using query string parameters in the URL - Power BI | Microsoft Learn ?
Usually if the filter string works in the URL the same string will also work in the ExportTo API.
You should certainly not use the basic filter schema when calling the exportTo API.