How can we improve Power BI?

member properties ssas

Currently it's not possible to show the member properties of a dimension. For creating reports some of the metadata is stored in member properties and needed for reporting questions.

94 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Diederick shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

11 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Up! At the moment you can do this easily in Excel Pivot Tables but in "Power" BI this is not possible! Come on MS... Give Power BI some power when working with SSAS Multidimensional!

  • Anonymous commented  ·   ·  Flag as inappropriate

    Up. This is still a problem even after three years. Cube processing takes hours because we need to aggregate by every attribute, since we can't access member properties through a live connection.

  • Peder Ekstrand commented  ·   ·  Flag as inappropriate

    In our cubes handling financial data we, for different god reasons, store the meaningfull descriptive texts for dimension members in a properties and without being able to render those properties as labels in the ui we can't use power bi. Prefered would be to be allowed to concatinate properties like property1 + " - " + property2

  • BdA commented  ·   ·  Flag as inappropriate

    The Cube.AttributeMemberProperty M function is poorly documented and does not seem to work at all.

    Please either provide valid examples of use - ex with intrinsinc member properties - or fix this function.

    In my context, multidimensional cubes are the main source of data for Self-Service BI users, and we need PowerQuery to better handle this source type.

  • Tony DeFelice commented  ·   ·  Flag as inappropriate

    You can access member properties by using a direct MDX query, although this is not suitable for non technical staff.

  • Jim commented  ·   ·  Flag as inappropriate

    I have Latitude/Longitude information as member attributes of a level of a geographical hierarchy and I can't seem to expose them to the map Lat/Long fields in PowerBI desktop. The ability to do so would be very convenient.

    Any ideas?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.