Cross Filtering with Multi Dimensional SSAS

Hi

We have a new SSAS cubes I am wanting to build some reporting on.

I am wanting to make sure of the existing model etc so am importing as live so I can access the whole cube.

I am finding issues with cross-filtering between dimensions, eg filtering on a field in a dimension correctly filters the measure groups, but related filters (fields from other dimensions within the same cube) are not filtered based on the data selected so am seeing the full data set options.

(eg opportunities dimension is filtered by owner, but the list of related account names in the account dimension still shows all accounts for the entire dataset, not those that should be related to the opportunities dimension).

I have asked the dev building the cubes and he doesn't know what the issue is and says its a power bi problem (and reckons excel is fine) and has no solution.

Anyone else have these issues?

If this doesn't work, I will have to resort to importing the dimensions separately and build the schema again. Whilst this is doable for me (yet a pain), this is not a solution for our 'self-serve' colleagues who don't have the skills to do this via desktop and want to be able to connect to the cubes via online gateway (most colleagues use macs which doesn't have the functionality needed in mac excel).