Issue while adding a field from the data set(fetched through a SSAS cube via live connection)

Hi again!

I managed to solve my issue. Like I suspected it had to do with the attribute key and the relationships defined in the dimension. Since we recently removed some hierarchies, and decided to hide some attributes, some relationships were also changed. This attribute used to be the lowest level in a hierarchy and the "middle level" is not there anymore. The relationship defined between this attribute and the key attribute was not valid I guess, at least from PBI for some reason. I'm not sure why it still worked in Excel. I know Excel and PBI interact with the cube in different ways, and I guess this is just another example of it. Somehow they see the cube and it's contents different from each other.

The key that we had specified for our "problem" attribute was a collection of two attributes, to enable us to build a proper hierarchy on it. By removing the 2nd attribute we had defined in the key, the problem disappeared for me. The composite key is not needed anyway since the hierarchy has been removed. Maybe It can be solved by just modifying the relationships as well.

So my advice is that you look into your attribute key, and your attribute relationships, and make sure they make sense. Can't say I'm 100% sure exactly why this solved it for me, but it somehow made sense to do it...