Combine 3 SharePoint List into one table in Power Bi

Hi vsolanon ,

If the "identifier 1" and "identifier 2" columns are custom columns(created in Power Query Editor), we can try to merge list 1 and list 2 based on the "identifier 1" as a new query, then merge with the list 3 based on "Identifier 3" after expand the new query. But if the three columns are created as calculated column, we suggest to convert them into custom column so that it can merge and expand easily.

If it does not meet your erquirement, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here.

Best regards,