Unanswered

Export To File for Power BI Reports not filtering with escape character

(0) Share

Report

Posted on by RK-27111646-0

I am using the 'Export To File for Power BI Reports' Action in a Power Automate with ReportLevelFiltering. The filter value have + character and I encoded it to %2B. The Power BI Report is not filtering with that filter. If I take the filter text from the power automate parameters box and put in the Power BI Report URL like 'filter=******' the report is being filtered properly. So there is no use in the format & content of the filter rule. Any feedback what could be happening in Power Automate 'Export To File for Power BI Reports' Action?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

That's not how you escape characters in these queries. You also blacked out the table and column names - these need to be escaped as well.

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

Was this reply helpful? Yes No
RK-27111646-0 9 on at

Like (0)

Report

@lbendlin
The Table Name and Column Name do not have any space or special characters, it only have _.

When I copy the filter value in the Power Automate Parameters screen in the Power BI URL with 'filter=' the visuals are filtered correctly. Here it shows the filter selected properly with filter on URL.

This is how I coded in the Power Automate filter string

The parameter screen I posted with my question is from the executed flow input.

Was this reply helpful? Yes No