Forum Discussion
Power BI
Hi ALL,
I have few questions.
1. Does Power BI supports Dataware house model??
2. Does Power BI Supports Cubes etc??
3. What is the backend for power bi ?? ( I mean to say for eg for Tibco Jaspersoft'S jasper has mysql database as backend to store job's information etc)
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
7 Replies
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.
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
