If you use the 'Entire organization' setting when providing permissions to users in the Power BI app, you have to set the equivalent permission setting in OneDrive or SharePoint for the Excel workbook. When sharing an Excel workbook via a Power BI app, you have to provide Build permissions to the dataset in the app and permissions to the OneDrive or SharePoint location for the Excel workbook.Analyze in Excel is only supported on computers running Microsoft Windows. You need to make sure you have a compatible version of MS Excel such as 2011 Service Pack 1 (SP1) or 2016 (version 15.30 or higher).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.If you dont enable the macro(s), you wont be able to delete your macro.Step 3, Click the. This will enable the macro(s) that are embedded in the file. Its in the yellow bar at the top of the Excel window. This will open the file in Excel.Step 2, Click Enable Content. Your dataset in Power BI must have pre-defined measures. Double-click the Excel file which contains the macro you want to delete. 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:

Enable content in excel 2011 for mac