Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
akj2784
Post Partisan
Post Partisan

Need advanced data modeling concepts of Power BI

Hi All,

 

Where can I find advanced data modeling concepts for Power BI. No where I could find the explanation of creating complex model with multiple fact tables, multiple dimensions.

Any good explanation of Relationship in Power BI. 

Any help would be really appreciated.

 

Regards,

Akash

 

1 ACCEPTED SOLUTION

@akj2784,

You can create relationships as follows.
1.JPG

Then create table visuals as shown in the screenshots below. 
2.JPG3.JPG

If above steps don't help, please share sample data of your tables for us to analyze.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

@akj2784

 

Hi @akj2784,

 

Have you found any other solution for this? 

 

I am in a question that whether Power BI can replace SAP Business Objects Universe. Can Power BI handle a model with lot of fact and dimension under direct query without impacting the performace of the reports?

 

Regards,

Maddy

v-yuezhe-msft
Employee
Employee

@akj2784,

I would recommend you read the Analyzing Data with Power BI and Power Pivot for Excel book mentioned in this blog about creating data model, and review the blogs below to learn more about handling relationships in Power BI.

Multiple Relationships Between Tables in DAX
How to handle fact tables with different granularities in #dax #powerpivot #tabular


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have gone through the docs but somehow still need to understand how to model such scenarios where we have multiple fact tables. May I need to unlearn Oracle BI and not think Power BI similar to a traditional reporting tool. I am from datawarehouse background so I am thinking the model from sql point of view. But that's not gonna work.

 

But based on my current effort in exploring the uses cases, I feel there are not much documentation available from Microsoft the way Oracle has for each and every concepts.

@akj2784,

What issue or error message do you get when creating relationship between your tables?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Question.JPG

 Simple example of the scenario I am trying to achieve. Assume Product 1, 2 from Dim 1 has Funding record in the Funding Fact and its corresponfing VP is also tagged to Dim 2.

Now Product 3, 4 from Dim 1 has revenue record in Revenue Facts but not in Funding Facts. And its corresponding VP us tagged to Dim2. 

I have to query VP Name with some filter, its Total Revenue, total Funding for each product in a report.

Results should be something like this.

Result.JPG 

 

And at the same time using the same model, I want to create another report with Product , Revenue and Funding.

 

Let me know what approach I should take. And how the relationship should be defined considering I have only these 4 tables for now. Merging the table is not feasible depending on the data I have.

 

Thank you for helping me.

 

Regards,

Akash

 

 

@akj2784,

You can create relationships as follows.
1.JPG

Then create table visuals as shown in the screenshots below. 
2.JPG3.JPG

If above steps don't help, please share sample data of your tables for us to analyze.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,

This works great. Thank you so much for your help. 

Would you mind explaining why you made only 1 relationship as both way and rest of them as one way. I would like to understand the concept so that I don't end up asking similar question again.

 

Regards,

Akash

@akj2784,

It will not impact the results even if you made all the relationships as one way.

If your issue is solved, please accept my reply as answer, that way, other community members would easily find the solution when they get same issues.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.