Forum Discussion
Solved
Build Model in Analysis Services vs. Power BI
Hi everyone, A while back, someone said somewhere (a conference session or a Webinar - I don't remember) that you could build your entire multi-source model in SSAS Tabular rather than in Power B...
Yes, you can absolutely do that. Generally when you do it that way, you build out the SSAS tabular model using something like SSIS to ingest the information and then you connect live (DirectQuery) to the model in Power BI Desktop.
Yes, you should be able to create additional measures when you connect live to an SSAS tabular model. Perhaps one of these days there will be a unified connector framework where everything uses Power Query...wouldn't that be awesome?
One other note, you can import a Power BI Desktop model into Azure Analysis Services if you want to use SSAS that way.
