How to Apply Report Filters to Automated Power BI PDF Exports

Picture the end of the month. You have been looking into a dip in West’s sales when the East manager asks for her PDF. She wants to review her team’s results before meeting with the branch managers tomorrow.

You switch the region to East, select the completed month and check the totals before exporting. None of that takes very long on its own. But you repeat it for the next manager, then repeat it all again next month. Each time, someone has to remember which view belongs to which person.

With PBRS, you can save East’s selection in the job that prepares and delivers her PDF. The recurring export then uses that configured view, rather than depending on what you last happened to be investigating in your browser.

There are two choices to get right. Her region stays East, but the reporting month needs to move forward. Once you have dealt with both, she can receive a report that is ready for her meeting without first asking you to recreate it.

If this is an occasional request, selecting the intended view and making a supported manual PDF export may be enough. Open the resulting file before sending it, so you know it contains the view you meant to share.

For our manager’s monthly report, the repeated preparation is the part worth automating. Keep East as a fixed selection in her PBRS schedule. Then decide how the date selection should work: perhaps it should always show the last completed month, or perhaps your reporting process supplies the period explicitly.

A monthly schedule tells PBRS when to run. It does not turn a fixed October filter into November. Use a supported relative-date selection where it fits, or arrange for the period to be updated as part of the job’s preparation.

If more managers ask for their own copies, you can move to a documented data-driven setup that matches each recipient with the appropriate region. Start by getting East’s report right; it gives you a clear example of what each person should receive.

Begin with the sales report in PBRS and a test destination. In the schedule’s Report Filters settings, add the field that identifies the region. For this example, the model has a table called Region and a text column called Name. Your report may use different names, so select its actual field.

Choose the appropriate data type, filter type and operator, then set East as the value. The Basic Filter dialog below shows where those choices belong.

Next, add the reporting-period selection you agreed on. Preview the report and look at it as the manager will: does the heading show East and the right month, and does a familiar sales figure agree with the report you would have prepared by hand?

Choose PDF for the output and add the test email or file destination. Run the job and open the delivered copy. Compare East’s total with the intended report view, and check that a record you know belongs only to West is absent. Calling the attachment “East.pdf” helps someone find it, but the contents are what establish that the filter worked.

Try the next month before leaving it to run

Check how your chosen date setup will behave when the reporting period advances. East should remain selected, while the dates move to the period the manager expects. Once the test file is right, set the approved recipient and monthly timing.

Keep that first correct PDF as a reference. If someone later renames a model field, changes the report’s date logic or takes over the region, you have a useful starting point for checking the revised delivery.

Next month, the East manager opens a PDF with her region, the completed reporting period and the figures she needs for her branch meeting. You can carry on investigating West’s sales without having to stop and rebuild her view first.

Start with that one regional delivery and get it right from filter selection to the received file. When other managers need the same service, explore personalized Power BI distribution. The Power BI Report Automation guide shows how to bring those deliveries into your wider reporting routine.

Download the PBRS Internal Evaluation Guide