We have an OLAP SSAS cube with an Usage->Parent dimension.
Dimension data includes
- Key
- Parent
- Name
Data is structured at three levels where Parent points to the Key of its parent.
Key is defined with NameColumn->Name
So the users see
GrandFatherName ..... FatherName ..... SonName ....................... SonData
But we cannot make any filter to work on PowerBi.
When a GrandFatherName is selected, no data is displayed
When FatherName is selected, no data is displayed
When SonName is selected .... well, this is still more unusual, there is no SonName list, we get a list of <blank> values! so we don't know which Son are we selecting, but nevertheless, again no data is displayed.
Accessing the cube using Excel and a pivot table works as expected, any level of data can be explored and selected.
Any idea what can be wrong?
