Analyze in Excel report not working for end user

user_12859783 0
Viewed 3700

I have created reports using the Analyze in Excel feature. I have saved these reports into a shared location for the user to access. The user has access to the workspace as a viewer and has a pro license. But when he opens the excel file from the shared location, he is getting the Forbidden Activity ID error and cant refresh the data. 

I thought if I create the reports using analyze in excel then the user with a pro license will be able to view and refresh the excel report regardless of where it is saved? 

Can you please advise further? Is there something I am missing? 

Thanks 

Yasir

powerbi excel
1 Answers

You can use the Analyze in Excel option for those users set as the role 'Viewer' (Those set as Members or Contributors will have this access by default), by enabling the 'Build' permission.

In the Power BI Service, go to the workspace datasets and click on the '...' for more options: Dataset More Settings

Select the 'Manage Permissions' option

Dataset Full Options

This will give a list of the user and their permissions. Select the '...' for the user options and select the 'Add Build' Permission.

Power BI Add Build Permission

The user in the 'Viewer' role can now access the data set via Analyse in Excel

user_94684550
Related