Power BI

New

Data Modelling when connecting to SSAS Tabular

Vote (111)

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)

cca3b4fe 341b-4612-8d55-4ee5e8c0b701 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.

64ab97aa f9db-4972-ba5e-7c795ee5b2a7 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

fbfd007f f68d-4731-ac7c-4b5a8f9f4922 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.

7dfb9ec6 03d8-46e2-a1b9-324ded615ad3 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?