Connecting to 2 analysis services data marts

[DebbieE]

I have just had another question come through from a user.

If they have for example 2 Analysis services (Essentially data marts)

Can you connect up to both of these Azure Analysis services databases as one data set?

Or can you only ever connect up to one Analysis Serivce per report?

[chayanupadhyay · Accepted solution]

@DebbieE 

If i understood correctly, you are asking that can we connect to multiple Azure analysis service instance in single report?

As far as i know you can only connect to one Azure analysis service instance in single report in Live connection and import mode though i haven't tried in Import mode but i believe it will only allow one instance connection.

Hope this will help!!!

Please let me know if my understanding is incorrect or you found any way to connect.

Thank you,

Chayan Upadhyay