reportLevelFilter not filtering when using Power B...

MARKZI

Hello,

i have set up a databricks notebook that connects to the Power BI Services via Token. I'm trying to export the Dashboard to a pdf to send it via email. Everything in my code works, except the part where i need to filter my dashboard by one id before exporting it. In my dashboard i have a slicer set to the "my_existing_column_name" and i have cheked that both column and table are existing and dont have any spelling mistake. I'm not using Power Automate. Instead i'm directly calling the api:

payload = {
    "format": export_format, 
    "powerBIReportConfiguration": {
        "pages": [
            {
                "pageName": "replaced_for_security" 
            }
        ],
        "reportLevelFilters": [
            {
                "$schema": "http://powerbi.com/product/schema#basic",
                "target": {
                    "table": "my_existing_table_name",
                    "column": "my_existing_column_name"
                },
                "operator": "In",
                "values": ["S1 0.3"]
            }
        ]
    },
}

This is the syntax that i have found here (last reply):

https://community.fabric.microsoft.com/t5/Developer/ExportTo-PowerBI-Api-ExportTo/m-p/4807863

However this isn't working for me. Any ideas why my report is not getting filtered?

v-kpoloju-msft

Hi @MARKZI,
Thank you for reaching out to the Microsoft Fabric Community Forum.

As you have already validated the table and column names, the behaviour you are seeing isn’t due to a syntax or Databricks issue. This happens because the ExportTo Power BI REST API does not fully honor slicer-driven or UI-based filtering during export. While reportLevelFilters are supported in the request payload, the export engine doesn’t re-evaluate slicer selections the same way the Power BI service UI does, so the report can export successfully but without the expected filter applied. This is a known limitation of the ExportTo API rather than an issue with your code.

For export scenarios where filtering must be guaranteed, the recommended approach is to use report parameters instead of slicers and drive your DAX logic from those parameters. You can then pass the parameter value directly in the ExportTo request, which is fully supported and works reliably during export.

Microsoft documents this behaviour and recommends parameters specifically for programmatic exports:
1. https://learn.microsoft.com/power-bi/developer/embedded/export-to#report-parameters
2. https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft

Hi @MARKZI,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.