Share
Report
6Hello,
I am trying to filter Power BI reports from PowerApps and encountering an issue with values that contain special characters. Below are the two different formulas I am using to filter:
Formula 1:
VarDashScoreCardMonthly & "&filter=KPI/KPI_name eq 'EDI%20Orders%20%23'"
This formula is used to filter the value EDI Orders # and it works correctly.
Formula 2:
VarDashScoreCardMonthly & "&filter=KPI/KPI_name eq 'EDI%20Orders%20%25'"
This formula is used to filter the value EDI Orders % but it does not work. When I use this formula, I see the entire table without any filtering applied.
Notes:
- The variable VarDashScoreCardMonthly contains the URL of the Power BI report.
- Filtering directly within Power BI works fine.
- The issue only occurs when trying to filter values containing the % character. Other special characters (like #) work correctly.
I need assistance on how to resolve this issue. How can I filter Power BI reports from PowerApps using values that contain the % character?
Thank you.
Categories:
I have the same question (0)
All responses (
Answers (
