Power BI

Needs Votes

Data Modelling when connecting to SSAS Tabular

Vote (112)

T.J. Brown on 14 Apr 2016 04:37:25

We need to be able to mashup data online with enterprise data in a SSAS cube. To do this, we'll need the data modelling feature accessible when connecting to SSAS Tabular.

Comments (9)

Comments (9)

Aby Mathew on 06 Jul 2020 00:08:25

RE: Data Modelling when connecting to SSAS Tabular

STRUGGLE TO UNDERSTAND WHY POWER BI PUT OWN LIMITATIONS TO SSAS tabular.

Bas on 05 Jul 2020 23:18:33

RE: Data Modelling when connecting to SSAS Tabular

I believe this is pretty much the same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data-multiple-data-sources?page=1&per_page=20

Andrew T. on 05 Jul 2020 23:05:00

RE: Data Modelling when connecting to SSAS Tabular

It seems like this shouldn't be a problem. You CAN add data from SSAS to a report with SQL Data, but you can't start from a SSAS model and add data from SQL sources. For me, this would be the more sensible approach. I have most of the data I need in my SSAS model, I just have some other bits out there I want to combine sometimes.

Ralph Kemperdick on 05 Jul 2020 23:02:22

RE: Data Modelling when connecting to SSAS Tabular

This is indeed a key missing feature and hard to understand why Excel can connect to multiple sources likes SSAS and other, but PowerBI cannot. It might become a kind of complex problem under the hood, but in my case it would be sufficient to render the different data sources on different Report pages. May be this is easier to accomplish?