Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
11 | |
10 | |
7 | |
2 | |
2 |
User | Count |
---|---|
14 | |
10 | |
7 | |
2 | |
2 |