Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago
Solved

odata Report Level Filters Multiple Filters Same Column

I have this in the Report Level Filters of Power Automate on the 'Export To File for Power BI Reports' operation.  The filter doesn't work when applying multiple criteria to the same column.   Curr...
Need Help
  • BrianNeedsHelp's avatar
    BrianNeedsHelp
    1 year ago

    Thanks for the detailed explanation.  As I had mentioned in my previous post, I solved this by using bookmarks in PBI and referencing those in the "Export To File for Power BI Reports" action.  

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi BrianNeedsHelp 

Could you please try the following :

  • The Export to File request accepts only one report level filters entry; you must put your entire filter in that single string.
  • Inside that string, use the in operator to match multiple values of the same column (Power BI URL-filter syntax). or isn’t in the supported operator list. Example:
    Current_x0020_Hierarchy/Level3Value in ('Bob Smith','James Brown')​

Table/column names are case-sensitive and spaces/special chars must use the _x0020_ style; use straight quotes and escape apostrophes with ''.
Reference:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters