How to connect to two or more Analysis Services sources

[Lucas_amsn]

Hi

I would like to connect to two or more Analysis Services sources (Tabular model), but it seems that Power BI allows to connect only to  one.

How to do it?

Thank you!

[Anonymous · Accepted solution]

Hi @Lucas_amsn 

If you want to connect to multiple AAS data sources, you may not be able to create a strictly live connection. You can use DirectQuery for Azure Analysis Services.

You can refer to the following documents for help:

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jayleny

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