How to create these table joins in powerbi

[manoj_0911]

FROM
AG2_STATUS_SUBHOUR ag2
JOIN DATE_TIME sdt ON (sdt.DATE_TIME_KEY = ag2.DATE_TIME_KEY)
JOIN PERSONS p ON (p.USER_ID = ag2.USER_ID AND p.ORGANIZATION_ID = ag2.ORGANIZATION_ID)
LEFT OUTER JOIN TEAM_MEMBERS tm ON (tm.USER_ID = p.USER_ID)
LEFT OUTER JOIN TEAMS t ON (t.TEAM_KEY = tm.TEAM_KEY)
LEFT OUTER JOIN GROUP_MEMBERS gm ON (ag2.USER_ID = gm.USER_ID)
LEFT OUTER JOIN GROUPS g ON (gm.GROUP_ID = g.GROUP_ID)
LEFT OUTER JOIN DIVISIONS d ON (d.DIVISION_ID = p.DIVISION_ID)

I need to create an report , make sure all filters are working fine and do incremental refresh and publish and test , if everything is working fine.

https://drive.google.com/file/d/1S8zgfqwHnaYtVELKapqdV-9xVIaaSU1Y/view?usp=sharing

I'm not able to create the inner joins , and when i create the report with the default joins done by powerbi and publish using incremental refresh getting this error in powerbi service

[amitchandak · Accepted solution]

@manoj_0911 ,  Create fact AG2_STATUS_SUBHOUR

and Dimension DATE_TIME,

Combine PERSONS, TEAM_MEMBERS, TEAMS, DIVISIONS to create a person team table in power query (Use merge query)

Combine GROUP_MEMBERS, GROUPS into Gtoup dimesion.

Now join them in in data model. Power BI always show full data from Fact table (Many side  table). so you will have left join.

[manoj_0911]

Thank you so much for your reply, I tried this approach but faced issues while joining the 3, So going to attempt to merge all tables to 1