Send large report subscriptions to OneDrive SharePoint

Article
10/02/2024

APPLIES TO: Power BI service Power BI Report Builder Power BI Desktop

You can send all of your large reports, both Power BI (.pbix) and paginated reports, to OneDrive SharePoint.

Subscribe to your Power BI and paginated reports to deliver them to OneDrive SharePoint. Your full report gets delivered to the OneDrive SharePoint location that you can select when you set up your subscription.

Requirements

The requirements apply to users in the organization. To create a subscription, you need:

Permissions to access the report.
Access to a workspace backed by a Premium capacity or equivalent Fabric capacity.

Your Fabric admin (previously Power BI admin) needs to enable subscriptions in your tenant. If you’re an admin, see Enable subscriptions in the Power BI admin portal.

Here's how you subscribe to a full report to be delivered to OneDrive SharePoint.

From the top menu bar, open a report in the Power BI service. This can be a Power BI report or a paginated report.
Select Create a subscription.
We currently support Standard subscriptions. Select Standard.
Select the Attach full report option.

By default:
- Your subscription is given the same name as your report page. Optionally, change the name of the subscription to something more meaningful.
- Your name is populated as the Recipient.
Select the format that you want your report to be in.

Power BI reports support two formats:
- PDF (.pdf)
- Microsoft PowerPoint (.pptx)
Paginated reports support several formats:
- Microsoft Excel (.xlsx)
- PDF (.pdf)
- Accessible PDF (.pdf)
- Microsoft PowerPoint (.pptx)
- XML (.xml)
- Comma-separated values (.csv)
Select the type of subscription.
When you select OneDrive or SharePoint, select the folder location where you want the subscription to be delivered, and enter the subscription schedule to have your report delivered.
By default, the File Name is the same as the Subscription name. Optionally, you can change these values. Also by default, the option to append the file name with date and time is selected. You can unselect that.
Select the Start date, frequency of delivery, Scheduled time of delivery and Time zone. You can also select an End date, if you want.
Save the subscription.