According to Troubleshooting Analyze in Excel —— Some users have more than one Power BI account, and when Excel attempts to connect to Power BI using existing credentials, it may use credentials that do not have access to the dataset or report you want to access.
When this occurs, you may receive an error titledForbidden, which means you may be signed into Power BI with credentials that do not have permissions to the dataset. After encountering theforbiddenerror, when prompted to enter your credentials, use the credentials that have permission to access the dataset you're trying to use.
If you still run into errors, log into Power BI with the account that has permission, and verify that you can view and access the dataset in Power BI that you're attempting to access in Excel.
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 MicrosoftExcel 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 inPower BI Premiumor that the user have aPower 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 haveread 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.