Data modeling help

[KonstantinDA]

Hi, I'm having trouble figuring out how to solve this problem. I want to display photo thumbnails in a single table visual.

I have three sequentially related tables: ScoutReport, ReportPoint, PointIssue. So, one scout report can contain many points, and each point can have multiple issues.

The photos are stored in another resource - Photo. It has columns photoable_type (FieldScoutReport, ScoutReportPoint, ScoutReportPointIssue) and photoable_id.

I can create three separate tables and connect each one to its respective type, but then I need to filter a lot to select all photos for a single scout report.

I also tried connecting the three different photo tables to the last one in the chain - PointIssue, by using RELATED to link all the ids from ScoutReport and ReportPoint. This solution doesn't seem elegant due to many-to-many relationships.

Is there a more elegant solution for this, please?

[v-cgao-msft]

Hi @KonstantinDA ,

Try creating a bridge table between the ReportPoint, PointIssue tables:
Many-to-many relationship guidance
Many-to-many relationship guidance

You may also consider posting documents that do not contain private information and we will attempt to provide a more specific solution.
How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum