Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Power BI vs Data Warehouse

Hi All,    I was reading this great community thread on the pros/cons of a data warehouse vs Power BI.    http://community.powerbi.com/t5/Desktop/Power-Bi-vs-Data-Warehouse/m-p/78650#M32787   I...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Phil. 

 

I agree, Power BI worked great with data warehouse, except perhaps for not being able to combine data from the DWH which you might quickly want to mash up with other data and drill through - we still cant drill through to row detail [see records menu] held in SSAS Tabular from Power BI (which you can do if you import data into Power BI).

 

Additionally with direct query we can query underlying data in SQL Server and build a model in Power BI rather than needing to build the model in SSAS.

 

At the moment it feels like Power BI development is outpacing SSAS Tabular which is making some SSAS Tabuar functionality redundant.

 

Do we have a roadmap about how SSAS Tabular will be developed and integrated with Power BI, or will Power BI eventually replace SSAS Tabular?

 

Thanks!

 

Pbix

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
I'm not an MS insider so can't speak for sure. But remember that Power BI is SSAS tabular under the covers (all be it a cut down version running in diskless mode). The main difference is that PBI desktop is on a more regular release schedule. So I would expect to see these feature appear in future releases of SSAS tabular. Perhaps SSAS Azure will see them first.