Forum Discussion
Access (SQL Query) to Power BI Join
Hi mdalton
Thanks for reaching out to us.
please check your data according to this tutorial, NATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Learn
if this doesn't help, please share your sample file, then we will check it.
Also, you can try Merge function in Power Query, Power BI: Merge and Append Queries - Perficient Blogs
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
I know it is not related to the relationships. BECAUSE I went ahead and built summarize tables only containing the information I need and the variables that connect the tables. I went into manage relationships, connected them all with no trouble, adjusted my above DAX to the summarize tables I just built... Still got the same error "No common join columns detected. The join function 'NATURALLEFTOUTERJOIN' requires at-least one common join column."