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
Anonymous
Not applicable

Creating star /snowflake schema for developed SQL/HANA view in power BI

Hi Folks,

 

Lot of people talk about star/snowflake modelling in Power BI.

But my question here is,if we already have "Developed view /table" coming from HANA/SQL databases which consists of required columns and is combination of all types as in quantitative and qualitative data.Then is it advisable to build fact and dimension table separately in power BI using one single view.As all the required modelling is done in  the -  source table .

or how can we categorize this modelling type where we have one view which consists of fact and dimension related columns.

 

1 REPLY 1
MariusT
Helper II
Helper II

Have you read this article by Alberto Ferrari?

 

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

 

Might give you some insights.

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

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