How to implement a star schema

[akhaliq7]

I have two fact tables, they can't join due to a m:m relationship. I have read that a star schema design should be followed to fix this. What is the best way to add the dimension tables to my model. 1 way could be to get it directly from the oracle database my work uses but that contains a lot of steps. Is there another way I can create dimensional tables in power query using the rows and columns already present in the model.

[Greg_Deckler]

@akhaliq7 Star schemas are great but I have rarely in the real world ever seen a true star schema used in business models. They are always more complex than that. I would recommend a bridge table between your two fact tables with bi-directional relationships. Then you can add your dimensions to either fact table.

[akhaliq7]

I have tried that in my case the two fact tables won't filter properly i have order_id as the key column in the bridge table but then sales person is in both fact tables but will not filter correctly in both,

[akhaliq7]

unless i use sales person id as the key column in the bridge table but then order id will not be related in both tables.

[Greg_Deckler]

@akhaliq7 Going to need to see example data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[akhaliq7]

sorry can't post sample data or table data fields as it is for my workplace can get in trouble for sharing internal workings, its ok if you can't help I am going to look at some other resources for getting the job done. 

[Greg_Deckler]

@akhaliq7 Fake data is fine.

[akhaliq7 · Accepted solution]

Thanks for your time, I have managed to solve this issue I had.

[v-rzhou-msft]

Hi @akhaliq7 

I am so glad that you can solve your problem.Please kindly Share your workaround or Accept the helpful reply as the solution. More people will benefit from it. 

Best Regards,

Rico Zhou