Forum Discussion
Analyze Feature - Power BI Service
Hey team, how are you?
I have this Dashboard which is composed by a headcount week by week.
I have estabilished a RLS, in order to different director see only their information, and not others.
While in my Power BI Desktop, I can use the Analyze feature to understand fluctuations, but as soon as a role is taken, the feature disapear.
Any ideas of why I am losing the ability to use this powerfull tool?
Hi BrunoMiranda From my understanding, the Analyze feature needs access to the full dataset, but RLS restricts data to subsets, disabling it for security reasons. You can work around this by pre-aggregating data in measures or using a non-RLS report for analysis.
5 Replies
Hi BrunoMiranda From my understanding, the Analyze feature needs access to the full dataset, but RLS restricts data to subsets, disabling it for security reasons. You can work around this by pre-aggregating data in measures or using a non-RLS report for analysis.
Hi BrunoMiranda,
I wanted to check if you had the opportunity to review the information provided by BrunoMiranda Akash_Varuna. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi BrunoMiranda
Can you please give us more details as to where the analysis feature is not working, or a screenshot so that we can assist you better?
Also, you will need to make sure that you have added the users to the role once you uploaded to the power bi service. Here are more details. Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Hi BrunoMiranda,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi BrunoMiranda,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
