Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Report with Analyze in Excel not working

Hi Everyone,


I have a report made with Analyze in Excel option. The report has a pivot table with multiples levels to drilldown.


I have a list of users with RLS inplace within the dataset and with just READ permission like the first user in the image below.




With that configuration, they are not able to expand the pivot table. Only when I add the BUILD permission is that they are able to expand.


The issue is that I don't want them to have access to the fields in the dataset. 


Note: I found a Macro that hides all the options in excel to show the field list. But then they still can access a blank Analyze in Excel file and have access to the field list.


Is there a workaround  for this?


Any help will be much appreciated.



Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!