Hi,
I want to export Power BI Reports in PDF format via Power Automate with a specific filter applied. When I did the same via Power Automate Flow, this returned the entire page with no filter getting applied while doing it through SQL trigger after executing the SQL query for that filter.
The report has multiple values in the filter that need to be selected and we need a single filter getting selected each time and the report to be exported as PDF via power automate.
Is there a way around this?
I had tried using URL Query string parameters in Pages pageName -1 as well as ReportLevelFilters Filter to resolve this. Though the Flow ran successfully, it did not return the page/report with the desired filter value.
Also, making use of Bookmarks or uriQuery in Expressions yielded the same result.
If anyone knows a way to resolve this, it would be great!
Thanks
Lakshmi