I have an executive report that shows a monthly summary for each customer. Currently, the user has to filter the report for each customer, export that to pdf and then email it (its about 150 different customers). I'm trying to help them automate this by creating a workflow that would pass the filter through PA workflow and automatically export the report to PDF.
I've got the workflow working somewhat; The workflow iterates for each filter value, and creates separate PDF's for each, but the issue I'm having is that it's not filtering. I've searched everywhere to figure out what the issue is, but haven't found figured out what the issue is yet. See below screenshot of the flow:
I've set the column I'm using as a filter in the report's report level filter as well, so still not sure what else I need to do. I'm using the PA workflow button in the Power BI report to run this and added the same column to the workflow button as well. See screenshot of report below:
I know i'm close, just need this last missing part to get it to work. TIA!
