Exporting Specific Pages of Power BI Reports with Filters to PDF in Azure Fabric notebook

we have a specific requirement that I’m hoping to get some guidance on from this community. if anyone has done this kind of scenarios.

We need to automate process of reading the existing power bi report through code, and apply for specific user filter within specific page, and then export the filtered report as a PDF. The goal is to send this PDF via email to the appropriate users.

What I have tried

Able to read the report using powerbiclient with providing group id and reportid to connect. Within fabric notebook

Challenges I’m facing:

Navigating to the specific page.

Applying dynamic filters.

Download as pdf and write into Lakehouse.

NOTE: We need to achieve this through code implementation due to our organization being small and preferring to avoid the costs associated with purchasing a high SKU license.

6 comments