Advanced Editor

[barbaraferreira]

Good afternon,

I would like to know if it is possible to bring to queries in power BI advanced editor of power query without mergin queries. I'm gonna let an example attached.

[ray_aramburo]

Understood, then what you are looking for is the "Append queries" feature. 

Just be aware that you need to respect the majority of the table structure (same column names with same data type) otherwise you'll get a bunch of nulls.

[ray_aramburo]

Are you trying to create a copy of a different query in a new Power BI file?

[barbaraferreira]

I'm trying to bring to queries in just one power BI file instead of creating a lot of differents tables. 

In this case, I don't wanna merge this tables with the option of merging queries in power query, I wanna put this two queries in the same file of the advanced editor.