Forum Discussion

PC_PBIGUY's avatar
PC_PBIGUY
Frequent Visitor
3 years ago

How to populate Scorecard Hierarchies

I am looking to set up a hierarchy in my scorecard by organization and noticing something strange. I have created the hierarchy and the preview shows correctly but in the actual scorecard, the dropdo...
General Comment
Need Help
Show and Tell
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , PC_PBIGUY 

 

Based on my research and understanding on the hierarchy feature in the Power BI Scorecard, please first check if you met any of the limitation of the additional considerations for viewing a hierarchy in the Power BI service:

Premium or PPU workspace is required.

There are data limits on hierarchies:

  • Up to 10,000 items per hierarchy (across all datasets)
  • Up to five hierarchies
  • Up to five levels per hierarchy

Permissions can't be set at a hierarchy level – metric level permissions are set at the scorecard and applied to all hierarchy views.

Data connections are evaluated by impersonating the hierarchy owner/creator where row-level security (RLS) may apply. This does not change metric level permissions.

Dynamic and static RLS is supported but it is routed through the hierarchy creator. All scorecard viewers impersonate the hierarchy creator’s access.

Hierarchy permissions can't be set at a specific hierarchy level. Metric level permissions are inherited from the original scorecard and are applied at all levels, and RLS via the hierarchy creator dictate permissions.

Non-admin users may experience refresh issues when setting up hierarchies on a dataset with dynamic RLS.

Manual metrics are indicated by an information icon showing which values are manual for that metric.

Notifications regarding status changes on child scorecard levels aren't triggered.

There is a limit of one selection per hierarchy for viewing a hierarchical scorecard.

History for hierarchical metrics isn't supported because data is always queried live from the dataset, instead of cached when the dataset refreshes.

Saving and sharing heatmap views isn't yet supported.

 

For more info, you can also refer to this official link:

View hierarchies in Power BI metrics - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly