Query based on tables without relations?

Hi Cipriano ,

You can use "Merge Queries as new" in Power Query and the expand the columns you need.

Final output:

Or you can try what FreemanZ  suggested to use TREATAS function which is best for use when a relationship does not exist between the tables.

You can reference the following document.

Merge queries overview - Power Query | Microsoft Learn

Virtual Relationship with TREATAS - Microsoft Power BI Community

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.