
Analyze in Excel is only supported on computers running Microsoft Windows.Analyze in Excel is a Power BI service feature, and isn't available in Power BI Report Server or Power BI Embedded.Guest users can't use Analyze in Excel for datasets sent from (originating from) another tenant.Read more about Build permission for datasets. A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset.To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing. Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.If you’re unable to install the updates, check with your administrator. Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel.Your dataset in Power BI must have pre-defined measures. Excel PivotTables do not support drag-and-drop aggregation of numeric fields.Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.Here are some requirements for using Analyze in Excel:
