Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I want to turn off the "Analyse in Excel" feature for my datasets, as implementing RLS is not possible at the moment and i don't want my final users to see more than I show in the report. I manage to disable it in the report disabling the compilation access of the dataset and this greyed out the Analyse in Excel option, but I found another way of accesing.
If I share the whole application, I have to share the dataset too. The user can enter My Workspace and the dataset will appear there. If he clicks the three dots, the following menu will appear and it will give access to the whole database. Is there a way to disable this?
I already asked the administrator to disable the option in tenant settings to no avail.
My source is Analysis Services
Thank you in advance
From my tests you can stop the use of Analyse in Excel as follows - this is all using the NEW workspaces:
For me this then "greys out" the Analyse in Excel option.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
11 | |
11 | |
4 | |
1 | |
1 |
User | Count |
---|---|
19 | |
16 | |
3 | |
2 | |
2 |