Power BI

[RakeshP]

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)

[itchyeyeballs]

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.

[RakeshP]

Do u mean "without any issue" for the last statement in your reply??

[itchyeyeballs]

lol, yes, I noticed the typo but the website is slow today and the edit took a while to do.

[greggyb]

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).

[HarrisMalik · Accepted solution]

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

[RakeshP]

Hi HarrisMalik,

Thanks for the info.

in the 3rd question what i mean is the what is the backend database supporting Power BI ??

[ashishrj]

@RakeshP Might be SQL Server Databases hosted on Azure Cloud. Or Power BI admin can answer this question 🙂