Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue Facing in Data Modeling

Hello, I am facing issue while creating relation, Power BI is creating Many to Many relation, while I have unique data (Product ID) in one table i.e Product table while other table is Sales table in...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Sorry for that I could not reproduce your issue on my side:

 

My PBI is Version: 2.102.845.0 64-bit (February 2022), and I'd suggest you always use the latest one to test.

 

In addition, if possible, could you please share some dummy data to help us clarify your scenario?

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous 

    Helo Eyelyn,

    Thanks for your reply.

    BI version I'm using "2.102.845.0 64-bit (February 2022)".

    Issue still exist, for the time being I have checked the data in excel. Excel marked few product as duplicate so I removed that duplication. I wondered why this happened.

    After this relation created.

    I couldn't able to attach the file here as I dont have option to attach file, please share your email address so that I can share the data on one drive