Forum Discussion

mdalton's avatar
mdalton
Helper I
3 years ago
Solved

Access (SQL Query) to Power BI Join

Given tables A, B, C, D, and E where the column names (variables) are numeric (1,2,3,...), I have the following in Access: SELECT A.1, B.2, A.3, A.4, C.5, A.6, D.7, A.8, E.9,..., A.30 FROM (((A LEF...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

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.

mdalton's avatar
mdalton
Helper I
3 years ago

I ended up doing a merge... I don't know why I did not do that in the first place. Thank you.