Moving/migrating models between Power BI and SSAS

Hi jmillar,

So there are several tools/platforms:

1. Power BI Desktop

2. Power BI Service

3. SSAS Tabular

4. Azure Analysis Services (AAS) Tabular 

Each model represents XMLA code.

Of course, SSAS/AAS is a better way because it is an enterprise level of reporting. You have more control over the settings of the server, partitions etc. 

Power BI if better for self-service or light version of enterprise reporting. This is for now. I think in the 2019 year it may change because it will be much more extended. But, if you will start from Power BI and not from Tabular then you will be able to connect to any Desktop report via SSMS and copy XMLA deployment script and apply it for Tabular server. But import Tabular model into Power BI is impossible.

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!