cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RakeshP Regular Visitor
Regular Visitor

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)

1 ACCEPTED SOLUTION

Accepted Solutions
HarrisMalik Established Member
Established Member

Re: 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

7 REPLIES 7
HarrisMalik Established Member
Established Member

Re: 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

RakeshP Regular Visitor
Regular Visitor

Re: Power BI

Hi HarrisMalik,

 

Thanks for the info.

 

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

ashishrj Senior Member
Senior Member

Re: Power BI

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

Highlighted
itchyeyeballs Established Member
Established Member

Re: Power BI

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 Regular Visitor
Regular Visitor

Re: Power BI

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

itchyeyeballs Established Member
Established Member

Re: Power BI

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

greggyb New Contributor
New Contributor

Re: Power BI

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 108 members 1,454 guests
Please welcome our newest community members: