need help

[anithaMallam]

Hi Experts,

                  Need your help on one of the issue iam facing currently.iam pulling data from 6 sql queries and loaded the data into excel as iam facing server timed out issue when pulling the data from sql queries. i loaded the excel data into power bi and created a validation report for the regions.below screen shot shows the data model of the report.

the above screen shot is the report which i have created.i am creating the report to show the difference of different attributes present in source and my synapse db.all the 6 tables have almost all similar attributes when iam trying to join the tables based on region /timeperiod it showing many-many relationship.so i joined on accounted amount.now i have taken timperiod from india stg table and i want to filter the MEA AND EUR Tables as well.Could some one please help on this it will be a great help in proceeding further.

Regards

Anitha

[v-easonf-msft]

Hi, @anithaMallam 

Could you please  tell me whether your problem has been solved ?
As mentioned by @amitchandak , you need  to create mutiple dimension tables, and create a one-to-many relationship between the tables around the dimensions.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@anithaMallam , Either append these table in power query

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or

Create bridge/ dimension table like date , region source etc and join these dimensions with these table in 1-M

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

Also refer

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/