Forum Discussion
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.