connected features coming soon for users with Power BI free licenses

Excel and Energy BI are simplifying enterprise information discovery and evaluation, with new related options resembling PivotTables from Power BI datasets (now additionally out there on Excel for the web) and Organization data types. These options construct on shared applied sciences from the Microsoft BI ecosystem resembling Energy Question, and current integrations resembling publishing to the Power BI service from Excel.

To date, connecting to Energy BI information in Excel has been restricted to customers with the Energy BI Professional or Energy BI Premium Per Consumer (PPU) licenses (learn more about Power BI licensing). As extra organizations undertake Energy BI at a broader scale and supply entry via Energy BI Premium capability, we’re increasing the supply of related PivotTables and Group information varieties to organizations with this mannequin.

Quickly, as an alternative of requiring a Energy BI Professional or Energy BI Premium Per Consumer (PPU) license for every consumer connecting to Energy BI information in Excel, it is possible for you to to make use of the Energy BI Premium capability on the group stage. This lets you maximize your investments in Microsoft’s analytics providers impartial of the expertise you select to investigate and visualize your information.

Listed here are some widespread questions on this alteration:

We’re growing the supply of related PivotTables from Energy BI datasets and Group information varieties in Excel, to incorporate customers with Energy BI free licenses which have entry to datasets in Premium capability of their organizations (along with current entry for Energy BI Professional and Energy BI Premium Per Consumer licenses).

  • As a consumer with a Energy BI Free license, can I exploit any dataset shared with me in Excel?

Customers with a Energy BI Free license can use datasets that they’ve entry to. This implies datasets in Premium capability, or “My Workspace”. Different necessities resembling construct permissions apply. Study extra about Build permission for datasets.

  • When is the change taking place?

We’re beginning to deploy the change within the coming days and anticipate all customers within the Present Channel to have entry with Premium capability over the approaching weeks.

  • Can I entry datasets in Energy BI “My Workspace” with this alteration if I don’t have Premium capability or a Energy BI Professional / Premium Per Consumer license?

Sure, as a part of this alteration customers with a Energy BI free license can entry datasets in “My Workspace” to be used in Excel PivotTables or Group information varieties.

  • Does this imply that related PivotTables and Group information varieties are actually out there with Microsoft 365 Private and Household?

No, these options aren’t out there for customers with Microsoft 365 Private and Household.

  • Does this imply that related PivotTables and Group information varieties are actually out there in Workplace 2016 or 2019?

No, these options require a Microsoft 365 for Enterprise or Schooling subscription.

To get began:

Create a PivotTable from Power BI datasets

Convert text to an Organization data type

Analyze in Excel for Power BI

Subscribe to our Excel Blog and be part of our Excel Community to remain related with us and different Excel followers world wide.

Leave a Reply

Your email address will not be published. Required fields are marked *