This error may occur because a user can't connect to Power BI datasets. If you're trying to access a dataset that has a live connection to SQL Server Analysis Services or Azure Analysis Services data, you may receive an error message. Unable to access on-premises Analysis Services Then, verify that you can view and access the dataset in Power BI that you're attempting to access in Excel. If you still run into errors, log into Power BI with the account that has permission. After encountering the Forbidden error and when you see the prompt, type the credentials that have permission to access the dataset you're trying to use. This error means you may be signed into Power BI with credentials that don't have permission to access the dataset. When this situation occurs, you may receive an error titled Forbidden. When Excel tries to connect to Power BI by using credentials from one of those accounts, it may attempt to use credentials that don't have access to the desired dataset or report.

If you need to troubleshoot an issue in Power BI with Analyze in Excel, see the following sections:Ī user may have more than one Power BI account. Can't drag anything to the PivotTable Values area (no measures).Unable to access on-premises Analysis Services.If you need to troubleshoot an issue with Power BI data in Excel, see the following sections: If you encounter a scenario that's not listed below, ask for assistance on the Power BI community site, or create a support ticket. Start in Excel to connect to Power BI datasets.Start in Power BI with Analyze in Excel.

There are separate articles for different connection types.

Microsoft power bi for mac