Forum Discussion
Create PDF with all possible filter values ( or only specific filter values)
Hello,
I'm using PowerBI desktop, and have setup the page to be Letter size.
I have a dropdown for State & Month, and a card with sales data.
I need to create a PDF report: each page of this report needs to be a separate month and state.
How do i create this without having to manually change the dropdown values and press Ctrl+P every time?
I've attached pictures for reference
Thank You.This is the page in PowerBI desktopData ModelThis is how the PDF is generated currently
2 Replies
Daxmax you have to leverage power automate to iterate over values and the export to pdf. You can refer this doc and tweak as you see fit.
Export and email a report with Power Automate - Power BI | Microsoft Docs
Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Hello parry2k,
Thanks for your message.
I get the following error: "Report requested for export is not on dedicated capacity"
It seems I need to get PBI premium with reserved capacity to use Power Automate.
I dont have the budget to pay $5k for this feature at the moment.
Do you have any other ideas?
Thanks once again
