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.

90 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    9 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.