You’re offline. This is a read only version of the page.
18
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!
oh ok.. yeah I was actually using it as the variable filter, but during my testing, i think I switched it to try the power bi varaiables as well, never changed it back.. re-ran it again just now using that variable, still no luck.
Basically I'm asking why you don't use the variable for the filter?
What are you using the variable "distributor" for?
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
