Analyze in Excel error

Hi sm_accordion ,

I have tested on my side and it works well.

First, please log into Power BI with the account that has permission.

Then, please check if you meet these requirements:

• Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.

• Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures.

• Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.

• Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. 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.

• Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. A user could have this in several ways, such as being a member of the workspace containing the dataset, having a report or dashboard shared to them that uses the dataset, or having permission to an app that contains the dataset.

• The Analyze in Excel is a Power BI service feature, and is not available in Power BI Report Server or Power BI Embedded.

• Analyze in Excel is only supported on machines running Microsoft Windows.

For more details, you can refer to these documents:

https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel#forbidden-error;

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.