Forum Discussion

akhaliq7's avatar
akhaliq7
Post Prodigy
4 years ago
Solved

How to implement a star schema

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. ...
Need Help
  • akhaliq7's avatar
    akhaliq7
    4 years ago

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

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's avatar
akhaliq7
Post Prodigy
4 years ago

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. 

    • akhaliq7's avatar
      akhaliq7
      Post Prodigy
      4 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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