topic Programmatically Bulk Export to PDF - inconsistent behavior in Developer

Programmatically Bulk Export to PDF - inconsistent behavior

barakb321 — Mon, 18 Apr 2022 11:00:13 GMT

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

Re: Programmatically Bulk Export to PDF - inconsistent behavior

Anonymous — Thu, 21 Apr 2022 07:49:13 GMT

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.

Re: Programmatically Bulk Export to PDF - inconsistent behavior

barakb321 — Sun, 24 Apr 2022 07:13:22 GMT

Hi @Anonymous

Is it available on PBRS?

Thank you,

Barak