Forum Discussion
ReportLevelFilters is not working using PowerAutomate
Microsoft Employeemokumar I can't tell why it's not working for you in the API, but as I said whatever works in the URL query string (same table name/column name, filter value) is expected to work in the export API, and the report page should look the same as in the portal.
AmosHersch Can you provide an example of how that would look in Power Automate? Do the table name, column name, and filter value all need to be in the ReportLevelFilters section?
- AmosHersch
Anonymous same thing that works for you in Power BI portal URL, for example:
As described here Filter a report using query string parameters in the URL - Power BI | Microsoft Learn for filtering on a field you append to the URL:
?filter=Store/Territory eq 'NC'
So in the API it's equivalent to setting:
ReportLevelFilters = "Store/Territory eq 'NC'"AmosHersch Thanks for your response. I would love to see a working example of what you described. I've tried the approach noted in the link you shared as well as various other iterations of the filter parameter, and nothing's worked for me.