Forum Discussion

KarenFingerhut's avatar
KarenFingerhut
Icon for Responsive Resident rankResponsive Resident
3 years ago

Export To Excel Permissions With Security Groups but Splitting Out those Not Requiring Export

Good Morning

 

Hope someone can help please

 

I have a PBI report pubished to our Premium Workspace. Currently the users are in a Sercurity Group (as there are quite a few of them) The report originally did not require export to excel therefore this was disabled in report settings. I now need to enable this setting but for only a few of the users.

 

My question is,

  • if I enable this in report settings to allow export to Excel and republish the PBIX file to the workspace,
  • remove those requiring export permissions from their existing security group
  • create a new one (splitting the users out)
  • Give the new security group build permissions (keep build disabled for the original security group that export is not required) 

will the security group without build permissions be able to export too. Or would you advise creating a new workspace and adding a copy of the report with export permissions to that workspace and assign the new security group to that workspace

 

Hope this makes sense

 

Thanks for your help

Kind regards

Karen

2 Replies

    • KarenFingerhut's avatar
      KarenFingerhut
      Icon for Responsive Resident rankResponsive Resident

      Hi amitchandak 

      Thanks for your reply

      Yep already got that enabled and have some security groups in there. 

      So do the following

       

      • 2 x security groups. One where I want them to be able to export and the other with those not wanting to export.
      • Add the security group wanting to export to the setting, export to excel config
      • Enable export permissions in the PBIX file and publish

      This then means only the security group added to tenant settings can export?

       

      Just need to ensure i'm doing it correctly. 

       

      Appreciate your help. 

       

      Kind regards

      Karen