Retrieving hierarchy nodes with power_bi.get_member_properties on alternative hierarchy

[MariusWirtz]

Discussed in #866

^{Originally posted by Sven-Bo March 3, 2023}
The "TM1py Region" dimension has two hierarchies: the default hierarchy "TM1py Region" and the alternative hierarchy "TM1py City". Here is a screenshot of my "TM1py Region" dimension:

When I use the default hierarchy, "TM1py Region", the levels are present in the resulting dataframe. This is the code I used:

df = tm1.power_bi.get_member_properties(
    dimension_name="TM1py Region",
    hierarchy_name="TM1py Region",
)

However, when I use the power_bi.get_member_properties function to retrieve hierarchy nodes from the "TM1py City" hierarchy, the levels are not returned in the resulting dataframe. This is the code I used:

df = tm1.power_bi.get_member_properties(
    dimension_name="TM1py Region",
    hierarchy_name="TM1py City",
)

And this is the resulting dataframe:

I'm wondering if this is expected behaviour and how I can retrieve the levels when using an alternative hierarchy.

Thank you for your help.