Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I just wanted to know how we can give the users the option to analyse the report in excel if we have shred the reports through apps.
Also if we give these permissions does that mean users can access the workspace of the report?
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous
If you have shared the app with user and has given appropriate access then user can go to app and click 3 dots, see below pic. there user should have option "Analyze with Excel", which will download the excel file.
If you have not added users to the workspace, they won't be able to get into the workspace, however if you have given appropriate access to data, build data, then they can download, but no workspace. Hope this helps
Hi @Anonymous
If you have shared the app with user and has given appropriate access then user can go to app and click 3 dots, see below pic. there user should have option "Analyze with Excel", which will download the excel file.
If you have not added users to the workspace, they won't be able to get into the workspace, however if you have given appropriate access to data, build data, then they can download, but no workspace. Hope this helps
@Anonymous
You can provide permission in Admin Portal > Tenant Settings
Also, refer this article:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group