Forgot to load all of the columns I needed in the query editor - how can i combine the queries

[kendall]

Hi, My dataset had a lot of columns and I did not select them all the first time. As a result, I am unable to use all of the columns of the data set in the report section. The queries do not have any columns in common so I cannot merge them. How can I combine them so that I do not have to start from the beginning and select the proper columns? You can see here that the problem is that Power BI cannot establish a relationship between the data Thanks

[jbwtp]

Hi @kendall,

I am not sure if this mean starting from the beginning which you try to avoid, but you can use the spanner (or whatever it is called) icon on the right from the "Removed Other Columns" to adjust your selection at any time.

Cheers,

John