Forum Discussion
Power BI
HI Rakesh
Please spend some time to read about Power BI. You can read all about Power BI https://powerbi.microsoft.com/en-us/documentation/powerbi-service-get-started/
1. Yes Power BI supports data warehouse models
2. Yes Power BI supports SSAS Cubes
3. I do not understand what do you mean by backend system (Do you mean source systems?)
Regards
Harris
I believe Excel and PBI desktop use an in memory engine taken from SQLServer called xVelocity, as such there is no backend database. The raw data is held in a .xlsx (excel) or .pbix file and loaded into memory.
The system uses very powerful compression algorithms which means large quantities of data can be analysed very quickly and gets around the old excel size issues. There is a 250mb size limit in PBI but because of the compression used 100 million + rows of data can be stored and handled without major issue.
Do u mean "without any issue" for the last statement in your reply??
lol, yes, I noticed the typo but the website is slow today and the edit took a while to do.
Power Pivot Data Model = Power BI Data Model = SQL Server Analysis Services Tabular mode.
Power BI Desktop and Power Pivot run a private, slightly feature-reduced version of SSAS Tabular behind the application process. The features you're missing vary, but the largest by far is role-based security.
Power BI Web Service uses the same engine - I cannot speak to its specific implementation (what sort of multi-tenancy is used).
