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...
Idrissshatila
Super User
Super UserHello 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 👍