It seems as if only Text is available to select. We require the Key to be available to build relationships and to view data
'Just a heads up, I just tried the work around posted by Miguel below and it works but does require you to strip some values from the field. I used Text.Replace to strip the unwanted fields in order to get the actual key value. Example of adding Material Key Power BI: Query Editor -> Add Column -> Custom Column Option 1 =Cube.AttributeMemberId([Material] Result: [0MATERIAL].[000000000001024362] Option 2 =Text.Replace(Text.Replace(Cube.AttributeMemberId([Material]), "[0MATERIAL].[", ""), "]", "") Result: 00000000001024362 Not sure if doing the replace when adding the custom column is better or worse then creating a new replace values step but this allows me to replace the whole string in 1 step as opposed to 2 steps.
