Reports PBI- Massive Export to PDF

Reports PBI- Massive Export to PDFFollow
Rui Mateus
Rui MateusMar 09, 2023 10:55 AM
Good Morning, I have one PBI Report with information for multiplers user (200 ). The same template( …
1. Reports PBI- Massive Export to PDF

Rui Mateus
Posted Mar 09, 2023 10:55 AM
Good Morning,

I have one PBI Report with information for multiplers user (200 ).

The same template( Report), but wih diferent information for each user.

The mail goal is to export this information to PDF/Excel.

Thank you,

Rui Mateus

——————————
Rui Mateus
Controller
Barreiro
——————————

2. RE: Reports PBI- Massive Export to PDF

Silver Contributor
Ganesh Kumar
Posted Mar 10, 2023 05:40 AM
Hi @Rui Mateus

Use Row level security to split the data for different user with email id or any group. and use export option to download it in PDF

——————————
Ganesh Kumar
Data Analyst
——————————

3. RE: Reports PBI- Massive Export to PDF

Bronze Contributor
James Watts
Posted Mar 10, 2023 05:58 AM
You might be better off with a paginated report.

——————————
James Watts
Business Intelligence Analyst
——————————

4. RE: Reports PBI- Massive Export to PDF

Jesse Stark
Posted Mar 10, 2023 09:01 AM
You can use Power Automate and the PBI connector to export a report as a PDF. I load an excel spreadsheet with the value we want to use as the filter (in your case the user), but the special characters need to be replaced like you would if you were using URL filters (linked below). In most cases, you just need to replace spaces with _x0020_ (example: “John Doe” becomes “John_x0020_Doe” in your excel sheet).

From there, you loop through every row of your excel sheet and use the Export to file for Power BI Reports action. Save the file to a SharePoint or email it to the person as an attachment.

There are some prebuilt templates in Power Automate to get you started if you haven’t used Power Automate much in the past.

As a heads up, it takes about a minute to generate each report, so you’ll need to let this run for about 3 hours once you have it working.

Filter a report using query string parameters in the URL – Power BI | Microsoft Learn

——————————
Jesse Stark
Mr
Wauwatosa
414-514-2909
——————————