cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fz
Frequent Visitor

Analyze in Excel issue -HTTP server returned the following error: Forbidden Activity ID: F5831E9F

When I using analyze in excel function on WIN10, the error message shows up in the excel(please see the screenshot):

Serwer HTTP zwrocil nastepujacy blad: Forbidden Activity ID: F5831E9F-E877-4ACB-8537-65270C9E8C7C

 

HTTP server returned the following error: Forbidden Activity ID:F5831E9F-E877-4ACB-8537-65270C9E8C7C

fz_0-1627627572383.png

 

How can I solve this issue? Thanks.

 

 

2 REPLIES 2
Eyelyn9
Community Support
Community Support

Hi @fz ,

 

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 titled Forbidden, which means you may be signed into Power BI with credentials that do not have permissions to the dataset. After encountering the forbidden error, 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 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.

Refer to:
Analyze in Excel for Power BI - Power BI | Microsoft Docs

https://exceleratorbi.com.au/power-bi-analyze-excel-what-you-need-to-know/

 

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

lbendlin
Super User
Super User

make sure build access is enabled in the app.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!