Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
8 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
4 | |
2 |