Forum Discussion

barbaraferreira's avatar
barbaraferreira
Regular Visitor
3 years ago

Advanced Editor

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.

3 Replies

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

    • barbaraferreira's avatar
      barbaraferreira
      Regular Visitor

      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. 

  • 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.