I am trying to get some information on whether you should be building the data model in Power BI or develop it in SSDT for deployment to SSAS Tabular server. What are the pros / cons for each? How do you decide?
I have noticed that if you connect to the SSAS Tabular model on server, that you need to go back to that model to make any changes. If you do it in Power BI it's stored within the .pibx file. If you use SSAS server then it's only one model to manage?
Any assistance / guideance is appreciated.
They are both running on the same Vertipaq Engine. SSAS is more suitable for the Corporate BI development and PowerBI is product more suitable for self service bi deployments. However, the underlying technology is similar other than SSAS tabular is more rich in number of features such as enhanced partiiton and RLS features. more configurable.
However, PowerBI models are transferrable to SQL server 2016. It means you can develop your model in powerbi or powerpivot and later on can import in SSAS Tabular.
Complete BI Life Cycle and Microsoft is filling the gaps in these products to make the more and more beautiful.
I Love it!
It is currently relatively complex to get the data imported and then refresh is a whole other ball of wax. I really could not recommend it currently as a production solution.
There is an Idea out there to make this more streamlined:
I would vote for that.
As to your question, it is really a question of a few trade-offs/decisions that need to be made. With SSAS it is a much more complex setup. You are likely going to need a SQL Server database as well as SSIS packages in the mix. The reason is that SSAS data import only supports a limited number of data sources (compared to Power BI):
So, first issue is complexity. SSAS adds complexity and using just Power BI makes things relatively simple.
A couple of things that might rule one or the other approach out immediately:
Proud to be a Datanaut!
Hello,,, is there a guideline of how much is too much for PowerBI Import .
My use case is to develop PBI Reports via Data stored in Azure HDInsight.... I have been giving it a thought to move the model to Azure Analysis Tabular, however the data size is going to be a problem is a thought that I want to be convinced of..
Are there size estimation techniques that help in the PBI world. I am new to this,,, so pardon me if this sounds silly.
thanks in advance.
As @BhaveshPatel mentions this is can be a question of data governance. Having SSAS control your model can be very useful for things like corporate KPIs.
Some other considerations are:
Version control of pbix can be challenging, different versions of the file always creep out.
Distributing large pbixs over the network can below.
I'd definitely review the use cases before deciding where the final model resides.
Now that Data Flows are coming out, I would love to understand the difference between Data Flows and Tabular SSAS cubes. It seems like data flows are very flexible and require less tooling, so if they could compare in performance, cubes would be unnecessary.