Forum Discussion
Transfer one query from one data model to another
It's in the Advanced Editor. You were pasting M code so I figured you knew how to find it. Uploaded an example.
- one - this is an original query to a CSV built using the GUI
- two - another orginal query to a CSV built using the GUI
- Append1 - An "Append as New" query built using the GUI
- Query1 - This is a hand-built query that started with a Blank query. I copied and pasted the M code from the other queries and made the necessary edits as specified in the original article.
The important thing to remember when copying and pasting M code is to make sure that the references in each subsequent step refer to the correct previous step in the query. Also, watch your commas.
It's in the Advanced Editor. You were pasting M code so I figured you knew how to find it. Uploaded an example.
- one - this is an original query to a CSV built using the GUI
- two - another orginal query to a CSV built using the GUI
- Append1 - An "Append as New" query built using the GUI
- Query1 - This is a hand-built query that started with a Blank query. I copied and pasted the M code from the other queries and made the necessary edits as specified in the original article.
The important thing to remember when copying and pasting M code is to make sure that the references in each subsequent step refer to the correct previous step in the query. Also, watch your commas.
Hi,
Would you please be able to recommend some resources to learn more about Power Query, Advanced Editor and M Code.
I find it allot more powerfull then simple Excel.
Again, thank you for your help.
Kind regards,
Andrei