Forum Discussion
Power BI Metrics Hierarchy Not filtering
Hi All,
I have cretaed a scorecard in PowerBI Metrics. I am trying to use "Hierarchy" to filter the score cards but its not working for some user. It shows blank data (The report I am using a PowerBI live connection to data model).
P.S : using Premium work space and Pro account
Hi myati2801,
Thankyou for using Microoft Community Forum.
I understand you're facing issues with hierarchy filters in your Power BI scorecard, where some users see blank data. This could be due to Row-Level Security (RLS) settings, which restrict data access based on user roles. If RLS is configured, users without proper permissions might see no data. To address this, please review your RLS configurations as outlined in Microsoft's documentation:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft LearnAdditionally, ensure that your hierarchy filters are set up correctly and that there are no issues with the data model relationships. Misconfigured filters or relationships can lead to unexpected behavior.
If the problem persists, consider having the affected users clear their browser cache or try accessing the report from a different browser or incognito mode.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
4 Replies
v-sgandrathiCommunity Support
Hi myati2801,
Thankyou for using Microoft Community Forum.
I understand you're facing issues with hierarchy filters in your Power BI scorecard, where some users see blank data. This could be due to Row-Level Security (RLS) settings, which restrict data access based on user roles. If RLS is configured, users without proper permissions might see no data. To address this, please review your RLS configurations as outlined in Microsoft's documentation:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft LearnAdditionally, ensure that your hierarchy filters are set up correctly and that there are no issues with the data model relationships. Misconfigured filters or relationships can lead to unexpected behavior.
If the problem persists, consider having the affected users clear their browser cache or try accessing the report from a different browser or incognito mode.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.- v-sgandrathi
Hi myati2801,
Thankyou for using Microsoft Fabric Community Forum.
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.- v-sgandrathi
Hi myati2801,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.