my report

my code :

export_url = f".0/my/groups/{workspace_id}/reports/{report_id}/ExportTo"
headers = {
    "Authorization": f"Bearer {access_token}",
    "Content-Type": "application/json"
}
payload = {
    "format": "pdf",
    "powerBIReportConfiguration": {
        "reportLevelFilters": [
            {
                "filter": "EXT_SYS_CODE in ('XNET', 'TW')"
            }
        ]
    }
}
export_response = requests.post(export_url, headers=headers, json=payload)

reportLevelFilters does not work. The downloaded report still contains other EXT_SYS_CODE data. Please tell me possible reasons.

It is expected that report level filtering can be used.

my report

my code :

export_url = f"https://api.powerbi/v1.0/my/groups/{workspace_id}/reports/{report_id}/ExportTo"
headers = {
    "Authorization": f"Bearer {access_token}",
    "Content-Type": "application/json"
}
payload = {
    "format": "pdf",
    "powerBIReportConfiguration": {
        "reportLevelFilters": [
            {
                "filter": "EXT_SYS_CODE in ('XNET', 'TW')"
            }
        ]
    }
}
export_response = requests.post(export_url, headers=headers, json=payload)

reportLevelFilters does not work. The downloaded report still contains other EXT_SYS_CODE data. Please tell me possible reasons.

It is expected that report level filtering can be used.

• python
• azure
• filter
• powerbi
• report

• Are you using import mode, direct query or live connection? – Pratik Lad Commented Mar 31 at 11:07

1 Answer 1

Troubleshooting reasons for API filter failure:

1. Report-level filtering in the Export API works only if the report uses Import Mode or DirectQuery. It does not work with Live Connection.

2. Use datasetFilters instead of reportLevelFilters, if report is based on "Live Connection/Direct Query":

payload = {
    "format": "PDF", 
    "datasetFilters": [  # Using datasetFilters instead of reportLevelFilters
        {
            "filter": "TableName/EXT_SYS_CODE in ('XNET','TW')" 
        }
    ]
}

3. Include Table name in your Filter format, so, the updated format will be:

import requests

export_url = f"https://api.powerbi/v1.0/my/groups/{workspace_id}/reports/{report_id}/ExportTo"
headers = {
    "Authorization": f"Bearer {access_token}",
    "Content-Type": "application/json"
}

payload = {
    "format": "pdf",
    "powerBIReportConfiguration": {
        "reportLevelFilters": [
            {
                "filter": "TableName/EXT_SYS_CODE in ('XNET','TW')"  
            }
        ]
    }
}

export_response = requests.post(export_url, headers=headers, json=payload)

4. If multi-value filtering (in ('XNET','TW')) does not work, try testing a single value first:

"filter": "Tablename/EXT_SYS_CODE eq 'XNET'"

5. If your report has a Parameter for EXT_SYS_CODE, use this instead of filters:

"powerBIReportConfiguration": {
    "parameters": [
        {
            "name": "EXT_SYS_CODE",
            "values": ["XNET","TW"]
        }
    ]
}

• Check the attached Microsoft documentation for more information regarding Filtering a report:

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn