Forum Discussion
Unable to get accurate data using Many-to Many relationship
I have two tables. 1st table has runs of the jobs executed on each dedicated sql pool and 2nd table consists of cost for each dedicated sql pool cost and additional resources like cognitive services,firewall etc for particular month. both tables has duplicates. Related using Many- to -Many relationship. not getting accurate data.
No luck.
Could anyone help on the this and provide referance articles, really helps. Thanks
@
1 Reply
Hello Dinkar ,
convert your model into a star schema and link the dimension tables to both tables you have then view the result by the dimensions.
refer to this documentation for star schema model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
