Programmatically Bulk Export to PDF - inconsistent behavior

[barakb321]

Hello,

We have a process that answers the need to create PDF reports based on a "Template".

We fomatted a Power BI report as the template. It has 6 tabs.

A python script opens an Excel file + the report in Power BI Desktop.

For each row in the Excel (this month we have 69) the script filters the Power BI and then sends CTRL + P to the operating system, which should result in exporting the report to PDF. At the end we should have 69 temporary libraries, each with a PDF named Rep1.pdf

This works for the first iterations of the loop, but for later rows the CTRL + P results in a file name section-000x.pdf (x changes between 3 and 6) and the corresponding pdf has only one page.

I tried to find out how a keyborad action can result in printing only one tab, and all the documentation says that it's not possible.

Does somebody have a clue what happens here?

Thanks,

Barak

[v-rzhou-msft]

Hi @barakb321 

If you want to export powerbi report as PDF and store them in some centralized location automaticlly.

You could refer to this blog.

E-Mail Subscriptions for Paginated Reports is Now Available

You will need a Premium license to do it.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[barakb321]

Hi @v-rzhou-msft 

Is it available on PBRS?

Thank you,

Barak