How to Attach the Full Power BI Report to a Subscription Email
Your manager opens the report email before the monthly review. The summary is there, but she still needs the rest of the report to prepare for the meeting.
PBRS can prepare the required pages as a PDF attachment and email it on schedule, so she has the document she needs without chasing you for a copy.
She needs the report, not just a glimpse of it
Imagine your operations manager getting ready for the monthly review. She opens the report email and sees the Summary page. It gives her the headline figures, but the questions she wants to ask are in Backlog and Service Levels. She replies to you: “Could you send me the whole report?”
You export the PDF and email it back. She can now read all three sections, save a copy with her meeting notes and take it with her when she is offline. Next month, she will need the same thing again.
A preview helps her recognise the email. The attachment is the document she can actually keep and use. In an eligible Power BI subscription, the full-report attachment option may cover that request. PBRS gives you another way to manage it: save the required pages, PDF settings, filename and email destination as one recurring job.
For this Monthly Operations report, start with what she needs for the review: Summary, Backlog and Service Levels, in that order, for the completed reporting month. That gives you a concrete document to prepare and check.
Ask what she takes to the meeting
Does she read the PDF on a laptop, print it or save it beside her notes? Knowing that helps you check whether the delivered pages are comfortable to read.
See whether the subscription already covers it
For a standard Power BI report, an eligible Premium-capacity or PPU workspace offers PDF or PowerPoint attachments through Attach full report. If that gives your manager the right document and delivery, you may not need a separate process.
PBRS is useful when you want to keep the report’s page selection, file preparation, naming and email delivery together. You configure the Monthly Operations job once, test the copy your manager receives, and maintain that job as the report changes.
Whichever approach you choose, check what “the whole report” means to her. A PDF contains the rendered pages; it does not necessarily include every row behind a scrolling table. If she needs transaction detail that continues across pages, use a paginated design or an appropriate data export for that requirement.
Attachment formats, size and page limits
Native standard-report attachments must be under 25 MB. Microsoft’s main guide permits no more than 20 pages, while its troubleshooting wording is stricter and includes hidden pages. Test a report near that boundary in its actual subscription editor.
Hidden pages can affect eligibility without appearing in the attachment. Paginated reports offer additional formats, subject to their settings and parameters. Dashboards do not have the equivalent full-report attachment control. See Microsoft’s subscription guide for the applicable conditions.
PBRS has its own supported rendering and destination limits. Check the generated PDF and your mail system’s attachment allowance; the size of the source PBIX file does not tell you the size of the email attachment.
A PowerPoint export supplies rendered pages as slides, rather than editable chart data. If you also include an interactive report link, the manager still needs the appropriate access to open it.
Check what the file reveals
An attachment already contains its data; the recipient’s interactive row-level security cannot remove it afterward. Native attachments reflect the owner’s rendered view. Review the email and preview separately, because attachment sensitivity labels do not protect those areas.
Prepare the PDF she will receive
Begin with a test copy of Monthly Operations. Confirm that the figures are ready for the completed month, then prepare the delivery using the approach you chose.
If you are using a Power BI subscription
Create or edit the subscription, enable Attach full report and choose PDF. Set the preview separately, then review the recipient and timing. Use Run now for a controlled test; it sends the current report without refreshing the model.
If you are using PBRS
Select Monthly Operations in the schedule and choose the pages for Summary, Backlog and Service Levels. Add an Email destination with your test mailbox, then select Acrobat Format (*.pdf) for the output.
Give the email a subject the manager will recognise and the PDF a filename that identifies its reporting month. A short message such as “Your monthly operations report is attached, including the backlog and service-level detail” tells her what to look for.
Keep attachment delivery for this job. The Embed report setting controls content in the email body, which is a separate choice from attaching the PDF. The PDF output guide and Email destination guide explain those settings.
Open the attachment, as she would
Run the job to the test mailbox and open the received PDF. Find each of the three sections in order, check the reporting month and read the smaller labels. Three pages alone are not enough: one could be duplicated, missing its visual or too cramped to use.
If only the preview arrives, check whether an attachment was enabled, whether the report met that route’s limits and whether an error was reported. Once the complete document arrives correctly, switch to the approved recipient and enable the monthly delivery.
Let her review the first copy
The manager knows which details she relies on during the meeting. A quick review together can catch an omitted section or an unreadable chart before the same issue returns next month.
Have your application request the finished report
Your application may already know when the reporting month is closed. At that point, it can ask PBRS to run the prepared Monthly Operations job, instead of someone opening the report and emailing a PDF by hand.
Keep the page selection and email destination in the tested PBRS schedule. The application starts that job and follows its progress, while the reporting team maintains the document the manager expects.
API example: run and monitor the monthly PDF delivery
This request pattern runs an existing single-report schedule. Use a valid access token and replace schedule ID 101 and the connection values with your own. Confirm the job’s recipients and test destination before executing it.
POST {pbrsBaseUrl}/api/Schedule/ExecuteScheduleAsync
Authorization: bearer {pbrsAccessToken}
Content-Type: application/json
{"ScheduleType":"report","uniqueid":101,"RunBy":"Monthly Operations ready"}
GET {pbrsBaseUrl}/api/Schedule/GetExecutionStatus?ExecutionId={ExecutionId}
Authorization: bearer {pbrsAccessToken}
Retain the returned ExecutionId with the reporting month. Follow the execution guide to monitor the job and inspect ResultJson. Keep credentials and recipient authorisation on the server.
Before connecting the request, configure the Email destination for Acrobat Format (*.pdf) and ordinary attachment delivery with EmbedReport set to false. In the supported RenderingSettings, numeric PagesToRender positions are one-based; an empty value selects all pages. Use the actual positions of Summary, Backlog and Service Levels.
Check the delivered PDF during integration testing. It should contain those sections, the intended reporting month and readable figures. If a request times out, investigate the existing execution before starting another so a delayed response does not lead to duplicate emails.
If you build the export directly with Microsoft’s API
Microsoft’s ExportTo route has its own eligibility rules and separate steps for starting the export, checking its status and retrieving the file. Page selections use internal names from the Pages API, rather than PBRS’s numeric positions.
Your application must also handle delivery and recovery from a failed attempt. Choose that route when you want to maintain those steps in the application; the PBRS example above requests a reporting job that is already configured.
Recheck the PDF when pages move
If someone renames, removes or reorders report pages, include the scheduled attachment in the review. A saved page selection needs to keep producing the document your manager expects.
Make the complete report part of her routine
Next month, your manager opens the email and finds the complete Monthly Operations PDF. She can read the backlog and service-level detail, save the file with her notes and arrive at the review prepared. There is no follow-up request for you to pick up first.
Start with that one document and check the copy that actually reaches her inbox. If the native full-report attachment meets the need, use it. For a recurring job that brings file preparation and delivery together, explore PBRS PDF scheduling and the wider Power BI Report Automation workflow.
Contributors:
Christian Ofori-Boateng
CEO, ChristianSteven Software
