Excel and Power BI are simplifying enterprise data discovery and analysis, with new connected features such as PivotTables from Power BI datasets (now also available on Excel for the web) and Organization data types. These features build on shared technologies from the Microsoft BI ecosystem such as Power Query, and existing integrations such as publishing to the Power BI service from Excel.
So far, connecting to Power BI data in Excel has been limited to users with the Power BI Pro or Power BI Premium Per User (PPU) licenses (learn more about Power BI licensing). As more organizations adopt Power BI at a broader scale and provide access through Power BI Premium capacity, we are expanding the availability of connected PivotTables and Organization data types to organizations with this model.
Soon, instead of requiring a Power BI Pro or Power BI Premium Per User (PPU) license for each user connecting to Power BI data in Excel, you will be able to use the Power BI Premium capacity at the organization level. This allows you to maximize your investments in Microsoft’s analytics services independent of the experience you choose to analyze and visualize your data.
Here are some common questions about this change:
We are increasing the availability of connected PivotTables from Power BI datasets and Organization data types in Excel, to include users with Power BI free licenses that have access to datasets in Premium capacity in their organizations (in addition to existing access for Power BI Pro and Power BI Premium Per User licenses).
Users with a Power BI Free license can use datasets that they have access to. This means datasets in Premium capacity, or “My Workspace”. Other requirements such as build permissions apply. Learn more about Build permission for datasets.
We are starting to deploy the change in the coming days and expect all users in the Current Channel to have access with Premium capacity over the coming weeks.
Yes, as part of this change users with a Power BI free license can access datasets in “My Workspace” for use in Excel PivotTables or Organization data types.
No, these features are not available for users with Microsoft 365 Personal and Family.
No, these features require a Microsoft 365 for Enterprise or Education subscription.
To get started:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.