Edit

Share via


Power BI add-in for PowerPoint - Admin info

The Power BI add-in for PowerPoint enables users to add live, interactive data from Power BI to PowerPoint presentations. This article provides Fabric administrators with essential information to manage the add-in in their tenant, including requirements, licensing considerations, and deployment options.

Requirements

To use the Power BI add-in for PowerPoint, users must either have access to the Office add-in store, or the add-in must be made available to them as an admin-managed add-in.

In national/regional clouds, the add-in must be deployed as an admin-managed add-in, since the Office add-in store isn't accessible from national/regional clouds. For more information, see Deploy the add-in in national/regional clouds.

Licensing

To be able to view live Power BI data in PowerPoint, users must have an active Power BI account and a Fabric Free license, and access to the data. If the Power BI report isn't located in a Premium capacity or Fabric F64 or greater capacity, a Power BI Pro license is needed.

If autolicensing for Power BI is enabled, users without a Power BI account are signed up automatically when they open a presentation containing a live Power BI report page or visual. This may impact the assignment and availability of licenses in your organization. For more information, see Power BI license assignment.

If autolicensing isn't enabled, users without Power BI accounts are prompted to sign up.

Power BI entry points

By default, the Power BI service includes entry points that enable users to insert the add-in into new PowerPoint presentations directly from Power BI. Power BI admins can disable this functionality by turning off the Enable Power BI add-in for PowerPoint tenant setting. For details, see Enable Power BI add-in for PowerPoint.

Note

Disabling this functionality in Power BI doesn't prevent people from adding Power BI report pages and visuals to PowerPoint slides starting from PowerPoint. To completely block adding live Power BI report pages and visuals to PowerPoint slides using the add-in, the functionality must be disabled in both Power BI and PowerPoint.

Power BI entry points for the add-in aren't available in national/regional, government, and air-gapped clouds. See the Microsoft Office documentation for information about the availability of the add-in in PowerPoint in these clouds.

Note

The rollout of the Power BI add-in for PowerPoint depends on the update cadence of your organization's Microsoft 365 subscription. Hence the add-in might not immediately be available in your organization. To ensure availability of the add-in, use the latest version of Microsoft 365.

Power BI add-in button in PowerPoint Insert ribbon (PowerPoint desktop for Windows only)

If your organization has a Microsoft 365 Office subscription, a button for the add-in appears in the PowerPoint ribbon when using the desktop application for Windows. This doesn't apply to PowerPoint for the web or if you're using a Mac.

Screenshot of the Power BI add-in button located on the Insert ribbon in PowerPoint desktop application.

The button is a shortcut to the add-in offering in the Office add-in store. The button itself doesn't provide access to the store.

Note

If access to the Office store is blocked in your organization, the Power BI button might not open a working experience for end users unless the add-in is deployed by your admin. When the Power BI add-in is provided through Centralized Deployment, the button works as expected without requiring users to browse the store.

Deploy the add-in in national/regional clouds

In national/regional clouds, the add-in is supported as an admin-managed add-in only. If you're a Power BI admin in a tenant located in a national/regional cloud, you must download the add-in from Power BI in your national/regional cloud and deploy it using Centralized Deployment. The add-in that's available from the public cloud doesn't work in national/regional clouds. Users in national/regional clouds must use the add-in you deployed.

To download and deploy the add-in:

  1. Sign into the Power BI service with an admin account.

  2. Select the Download icon and choose Power BI for PowerPoint to download the add-in. You have this option only if your tenant is in a national/regional cloud.

    Screenshot of the Power BI for PowerPoint add-in download option.

  3. Deploy the add-in according to the instructions in Deploy add-ins in the Microsoft 365 admin center.

For a summary of the ways the add-in differs when deployed in a national/regional cloud from when it's deployed in a public cloud, see The Power BI add-in for PowerPoint in national/regional clouds.