Edit

Send large report subscriptions to OneDrive SharePoint (Preview)

  • Article

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.

Screenshot showing in the Subscriptions pane, select create a subscription.

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:

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.

Subscribe to a report

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

  1. From the top menu bar, open a report in the Power BI service. This can be a Power BI report or a paginated report.

    Screenshot showing subscribe to.

  2. Select Create a subscription.

    Screenshot showing subscribe to paginated

  3. We currently support Standard subscriptions. Select Standard.

    Screenshot showing in the Subscriptions pane, create a standard subscription.

  4. Select the Attach full report option.

    Screenshot showing in the Subscriptions pane, 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.

  5. 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)

    Screenshot showing in the Subscriptions pane, select the format for the full report.

  6. Select the type of subscription.

  7. 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.

    Screenshot showing in the Subscriptions pane, select the subscription schedule for the report.

  8. 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.

    Screenshot showing in the File Name option.

  9. Select the Start date, frequency of delivery, Scheduled time of delivery and Time zone. You can also select an End date, if you want.

    Screenshot showing in scheduling.

  10. Save the subscription.

You receive the full report saved to the OneDrive or SharePoint location that you selected at the frequency that you selected.

Learn more about subscribing to OneDrive SharePoint.

Considerations and limitations

  • Microsoft Entra Business-to-Business (B2B) guest users can't choose OneDrive SharePoint.
  • Premium per user accounts can't choose OneDrive SharePoint.
  • You can't create a subscription that sends the report to OneDrive or SharePoint if the report is part of a Power BI organizational app.

Related content