Multiple data sources

[jcaranibar]

Is there a way to have many datasources including SSAS?

When I connect to a SSAS data source, Get Data is not enable to have more data sources. Why?

Thanks.

JCA

[Seth_C_Bauer · Accepted solution]

@jcaranibar I assume you are connecting via "Connect Live" - this disables any option to connect to other data because SSAS is the only source that you can use that connection type. If you selected "import" - you would be able to add other data sources, but you would lose the ability to work on the existing model.

Mixing live/direct/import connection types is not supported.

[eligoldner]

I was facing the same issue here - there seems to be a bit of a trade-off, which would be nice if MS can resolve. For SSAS, in order to preserve the hierarchies and relationships, you need to use a live connection, though by doing so, you lose the ability to blend the data with data from another source... oh well.