Answers

I think the easiest way to do this would be to create a one-row table in your sheet (one row plus headers) that has the same structure as the original table. You can create a query on top of this sheet table by using "From Table" in the Power Query ribbon
tab. Then use "Append" (also in the Power Query ribbon tab) to append the original and the newly created query.

All replies

I think the easiest way to do this would be to create a one-row table in your sheet (one row plus headers) that has the same structure as the original table. You can create a query on top of this sheet table by using "From Table" in the Power Query ribbon
tab. Then use "Append" (also in the Power Query ribbon tab) to append the original and the newly created query.

I know this is an older thread, but I've personally found that I prefer to not introduce additional physical tables in Excel to achieve this. Rather, I insert the "Unknown" dimensional record as a step using M:
Append = Table.Combine({#"LastStep", Table.FromRecords({[a=-1], [b="NO VALUE"]})})

The "easiest" way? how absurd...it should be as easy as right click to add a row to PowerQuery otherwise it lacks, dare I say, Power. Your everyday user will not find this intuitive and will quickly abandon the toolset.

Power Query has made great strides in taking some of the most common use cases and making them nice little ribbon options, but at the end of the day, ETL is a complex task - and the adding of records into an ETL flow has always required knowledge of either
SQL or SSIS transformation script language. Understanding "M" is necessary for those who would like to make Power Query into a truly robust ETL tool, and while I as a BI consultant would love to see such functionality, at the end of the day
there's always a bridge to be crossed for those who are willing to learn more, and those that do not wish to.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.