Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

Posted on 27 Nov 2024 16:50:34 by
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?
 
  • Suggested answer
    RK-27111646-0 Profile Picture
    RK-27111646-0 on 28 Nov 2024 at 02:17:44
    Export To File for Power BI Reports not filtering with escape character
    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.
     
  • lbendlin Profile Picture
    lbendlin 7,795 on 28 Nov 2024 at 01:54:07
    Export To File for Power BI Reports not filtering with escape character
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard