cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
paulineCom
Helper I
Helper I

OLAP Cube

Hello everyone,

 

I'm starting BI with Power BI.

Now, i'm learning about concepts of Datawarehouse, Datamart and cube. I could understand that these 3 notions can be built with the OLAP modeling model, I am wrong ??

 

For my case, I have a SQL Server database,, which contains my Datawarehouse. In Power BI Desktop, I connect a new repport with my SQL Server Database in DirectQuery , i select the dimensions tables and my fact table with which i want to work. Next, these tables appear in the model section and it's at this moment that's i start to create a dataset whith relation (star model) , measures and calculated columns.

 

I want to know if this dataset is the same as a OLAP cube ?

If i am wrong, i want to know if is it possible to create a OLAP cube in power BI ?

 

thank you for your answers

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
3 REPLIES 3
amitchandak
Super User
Super User

nvprasad
Solution Sage
Solution Sage

Hi 

 

For smaller dataset, it's perfectly fine to load data into powerbi and create a model. But if data is huge you can create an SSAS tabular model connect to PowerBI.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

 

Thank you for this answer, but that does not answer my questions which are :

 

I want to know if the dataset taht we build in Power BI Desktop  is the same as a OLAP cube built in SSAS ?

If it's not the same, i want to know if is it possible to create a OLAP cube in power BI ?

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors