Power Platform Community Forum Thread Details

Hi,

Solution 1: Use Power BI REST API with HTTP Actions (Recommended)

This gives you the most control over filters:

Step 1: Set up HTTP Authentication

Add "HTTP" action in Power Automate

Register an App in Azure AD for Power BI API access

Get authentication token first

Step 2: Apply Filters and Export

json

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo

Headers:
Authorization: Bearer {your_token}
Content-Type: application/json

Body:
{
    "format": "PDF",
    "powerBIReportConfiguration": {
        "reportLevelFilters": [
            {
                "filter": {
                    "$schema": "http://powerbi.com/product/schema#basic",
                    "target": {
                        "table": "YourTable",
                        "column": "YourColumn"
                    },
                    "operator": "In",
                    "values": ["FilterValue1", "FilterValue2"]
                }
            }
        ],
        "pages": [
            {
                "pageName": "YourPageName",
                "visualFilters": [
                    {
                        "filter": {
                            "$schema": "http://powerbi.com/product/schema#basic",
                            "target": {
                                "table": "Sales",
                                "column": "Region"
                            },
                            "operator": "In",
                            "values": ["North", "South"]
                        }
                    }
                ]
            }
        ]
    }
}

Solution 2: Use Power BI Paginated Reports (Best for Scheduled Reports)

Steps:

Convert your report to Paginated Report (.rdl)

Use "Power BI Paginated Reports" connector

Apply parameters dynamically

Power Automate Actions:

1. Export Power BI Paginated Report
   - Report: {YourPaginatedReport}
   - Parameters: 
     - Region: North
     - StartDate: 2024-01-01
     - EndDate: 2024-12-31
   - Format: PDF

2. Send an email (V2)
   - Attachments: Use output from step 1

Solution 3: URL Parameters with Export (Limited)

Steps:

Build filtered URL with parameters

Use Power BI "Export to file" action

Apply URL filters

Example URL with Filters:

https://app.powerbi.com/groups/{workspace-id}/reports/{report-id}/ReportSection?filter=Table/Column eq 'Value'

Power Automate Flow:

1. Initialize variable: FilteredURL
   Value: "https://app.powerbi.com/groups/12345/reports/67890/ReportSection?filter=Sales/Region eq 'North'"

2. Export Power BI report to file
   - Report: Use dynamic report selection
   - Pages: Specify filtered page
   - Format: PDF

3. Send email with attachment

Solution 4: Power BI Premium Per User (PPU) Solution

With PPU, you get more advanced export capabilities:

Flow Structure:

1. Get rows from Excel/SharePoint (filter criteria)
2. Apply multiple filters using HTTP action
3. Export report with applied filters
4. Send email with customized subject/body

HTTP Action for Multiple Filters:

json

{
    "format": "PDF",
    "powerBIReportConfiguration": {
        "reportLevelFilters": [
            {
                "filter": {
                    "$schema": "http://powerbi.com/product/schema#advanced",
                    "target": {
                        "table": "Sales",
                        "column": "Date"
                    },
                    "logicalOperator": "And",
                    "conditions": [
                        {
                            "operator": "GreaterThanOrEqual",
                            "value": "2024-01-01"
                        },
                        {
                            "operator": "LessThan",
                            "value": "2024-12-31"
                        }
                    ]
                }
            }
        ]
    }
}

Solution 5: Dynamic Filtering with Variables

Complete Flow Example:

1. Initialize variables
   - FilterRegion: "North"
   - FilterDate: "2024-07-21"
   - RecipientEmail: "manager@company.com"

2. Compose (Build filter JSON)
   {
       "filter": {
           "target": {"table": "Sales", "column": "Region"},
           "operator": "In",
           "values": [variables('FilterRegion')]
       }
   }

3. HTTP Action - Apply Filter and Export
   Method: POST
   URI: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo
   Body: Use composed filter JSON

4. Condition - Check if export succeeded
   If Yes:
     - Get file content
     - Send email with attachment
   If No:
     - Send error notification

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍. Regards, Riyaz

Community site session details

Export filtered report section from Power BI report using Power Automate

Solution 1: Use Power BI REST API with HTTP Actions (Recommended)

Step 1: Set up HTTP Authentication

Step 2: Apply Filters and Export

Solution 2: Use Power BI Paginated Reports (Best for Scheduled Reports)

Steps:

Power Automate Actions:

Solution 3: URL Parameters with Export (Limited)

Steps:

Example URL with Filters:

Power Automate Flow:

Solution 4: Power BI Premium Per User (PPU) Solution

Flow Structure:

HTTP Action for Multiple Filters:

Solution 5: Dynamic Filtering with Variables

Complete Flow Example:

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Export filtered report section from Power BI report using Power Automate

Solution 1: Use Power BI REST API with HTTP Actions (Recommended)

Step 1: Set up HTTP Authentication

Step 2: Apply Filters and Export

Solution 2: Use Power BI Paginated Reports (Best for Scheduled Reports)

Steps:

Power Automate Actions:

Solution 3: URL Parameters with Export (Limited)

Steps:

Example URL with Filters:

Power Automate Flow:

Solution 4: Power BI Premium Per User (PPU) Solution

Flow Structure:

HTTP Action for Multiple Filters:

Solution 5: Dynamic Filtering with Variables

Complete Flow Example:

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates