Forum Discussion
Issue with Applying Page Filters in Power BI ExportTo API
Hello lbendlin ,
I have finally resolved the issue! It turns out the problem was not related to the encoding or syntax of the filter. Instead, it was due to a mismatch between the data accepted by Power BI and the data available in the data models.
Thank you once again, lbendlin , for your response and guidance—it helped me stay on track to identify the root cause.
Best regards,
Jay Kanara
Hello lbendlin Thank you for taking the time to respond and provide guidance. I truly appreciate your effort to help.
I’ve tried several approaches with the filters, such as:
reportLevelFilters: [{
filter: `order_details/Attempt00x20Count in ('1', '2')`
}]
reportLevelFilters: [{
filter: `order_details/Attempt_00x20_Count in (1, 2)`
}]
reportLevelFilters: [{
filter: `order_details/Attempt00x20Count in (1, 2)`
}],
reportLevelFilters: [{
filter: `order_details/Attempt_00x20_Count in ('1', '2')`
}],
Unfortunately, none of these approaches worked for me. I wanted to clarify that this filter is meant to be applied at the page level, not the report level.
If you have any further insights or suggestions on how to structure the filter correctly for page-level filtering, I would be extremely grateful. Thank you again for your time and assistance!
Best Regards,
Jay Kanara
Please read the documentation again. Your encoding style is incorrect.
There is no such thing as page level filters for this scenario. Filters are applied to the data model as a whole.
Hello lbendlin ,
I have finally resolved the issue! It turns out the problem was not related to the encoding or syntax of the filter. Instead, it was due to a mismatch between the data accepted by Power BI and the data available in the data models.
Thank you once again, lbendlin , for your response and guidance—it helped me stay on track to identify the root cause.
Best regards,
Jay Kanara