work with three cubes simultaneously

[Juan-Power-bi]

I have my SQL Server Analysis Services server where my cubes are located,

I have three cubes where my clients' information can be found

I can with power bi merge the cubes and create a report based on the three cubes?
 

[v-deddai1-msft]

Hi @Juan-Power-bi ，

It is impossible to connect to three cubes in power bi by live connection, You can use the import mode, but that would flatten the cube and make it pretty unusable. For cubes you always want to stick to a live connection. 

There two workaround in SSAS:

1.Please try to design a new cube that contains all data in other three cubes.

2.Create a new Cube based on the existing cube and add linked objects (dimensions and measures) of other Cubes.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[daxer-almighty]

As far as I know, you can't query more than 1 cube in Live Query mode. I presume this is the mode you're using. But... you can import data from the cubes in the Import mode and then you'll be able to use all 3 cubes. However, problem is that you'll have to re-create manually all measures that you've got in the cubes and of course your model will potentiall be huge.