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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ScottBrown
Helper II
Helper II

Large Semantic Model - Inner/Outer Joins

Is there a good way to relationship modelling in Power-BI?

I am trying to mash up Dynamics GP Data and several external sources into a data warehouse putting it all in one Power-BI report as the "source of truth" data source/semantic model.

 

Since Power-BI does not do Inner/Outer joins-only in Power Query to merge queries and such,, I think I am stuck.

Trying to pass Sales Tables, Purchasing, and Invemtory.

 

Anybody have experience in modelling and trying to do inner/outer joins and no Inactive relationships?

 

 

4 REPLIES 4
audreygerred
Super User
Super User

Power BI LOVES star-schema/normalized data versus denormalized data. I suggest bringing in your three fact tables (i.e. sales, inventory, purchasing) and making metrics from them work together in visuals through relationships with dimension tables and measures. http://powerbiwithme.com/2023/07/30/the-star-schema-edition/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Do you have a minute where I can show you our project - maybe in a quick Teams meeting?

I can ping you on Linked In if you have time for a short talk..

 

I believe I am running up against a relationship mapping issue - active vs inactive.

I am in meetings until about 7pm EST, but feel free to connect with me on LinkedIn and we'll see what we can do.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Do you have a minute where I can show you our project - maybe in a quick Teams meeting?

I can ping you on Linked In if you have time for a short talk..

 

I believe I am running up against a relationship mapping issue - active vs inactive.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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