Hip, In redoing the lesson using pq_2_3 I could not refresh the July data into my table.
After I copy July data and right click refresh the new July data disappears from screen leaving only the original data. 
I have tried pushing other refresh buttons but same thing happens...
Hi Junko,
The green table from Sheet3 is the Output table, produced by the query.
The source table, as written in the query: = Excel.CurrentWorkbook(){[Name="Sales_Excl_Beverages"]}[Content], is the table from Sheet1, the blue one.
If you put data in the output table, it will be ignored, as this is not the source.
Put the new data into Sheet1 table, it will work.
Hi, thank you for the answer.
Just one more question where is the source code written for the query?
I could not find the following which you pointed: The source table, as written in the query: = Excel.CurrentWorkbook(){[Name="Sales_Excl_Beverages"]}[Content], is the table from Sheet1, the blue one.
Is the blue colored table always the source data?
Hi Junko,
By default Excel will format Tables in blue and Power Query tables in green. However, you can override these defaults so this is not always the case.
The source code is visible in the Advanced Editor. Please complete the course tutorials before trying to push ahead with your own work, because many of these questions will be addressed in the course.
Thanks,
Mynda
