Unanswered

ReportLevelFilters not working; seem to be ignoring filter altogether

(0) Share

Report

Posted on by PS-22081920-0

Hi,

So I'm testing the entire report-filtering functionality for the 'Export to File for Power BI Reports' module, and running into issues getting the actual filtering to work. I'm using a sample report (https://learn.microsoft.com/en-us/power-bi/create-reports/sample-regional-sales) and trying to filter the one unhidden dashboard on Territory (specifically US-WEST). My sample flow does not error out. It outputs 4 files (by design) but none of them are filtered at all. I also tested using a field name that is non-existent in the PBI semantic model to try to force an error, the flow ran anyway. So I'm thinking that the reportlevelfilter functionality straight up just doesn't work unless I am missing something?

I am eventually going to need this to loop through 120 different values and filter on each, but I can't even get this off the ground with hardcoded filters. Any help is appreciated.

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (0)

Sort by

stampcoin 5,158 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@PS-22081920-0 Hi,

Your filter has incorrect input and incorrect usage.

Query string parameter syntax for filtering：

URL?filter=Table/Field eq 'value'

In the sample data, Territories is the table name, Territory is the field/column name, you can use powerBI desktop to check that.

So, here the filter =Territories/Territory eq 'US-WEST'

The Detail input should be:

Or Array input:

Please read this :

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

Was this reply helpful? Yes No
PS-22081920-0 4 on at

Like (0)

Report
Copy link

Link copied!

@stampcoin that still does not work, and even still shouldn't incorrect syntax cause the flow to error out or return nothing? With incorrect syntax or a bogus filter, the flow is still running and outputting an unfiltered report.

Was this reply helpful? Yes No
stampcoin 5,158 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@PS-22081920-0 Hi,

The filter has correct syntax, but the fields not exist, you won't get any error.

If the syntax is incorrect, the flow will throw the error when you run it.

So, please double check on your side carefully.

You can use the URL to verify your filter.

For example, when you open Regional Sales Sample in PowerBI online,

in the address bar of your browser, remove experience=power-bi after question mark?

then add filter=Territories/Territory eq 'US-WEST'

It should be like https://app.powerbi.com/......?filter=Territories/Territory eq 'US-WEST'

if it give you the same result as without filter, then the field is not correct, you have to double check it.

You can go to the report, click .... (More options).

Then Choose 'Explorer this data (preview)'.

on the popup window, on the right panel, hove over your mouse on Territory field, it will give you the table/field data.

See below.

Was this reply helpful? Yes No