How to add comment column in power query based on external database

Question

I have a query that is taking its data from an external database (it is coming from our ERP). I cannot view or modify those data directly at the source. I need an extra column where I can enter a note. I can'T use formulas to generate it conditionnally because the possibilities of what that note can be are too vast. I have seen multiples posts and videos with how to do it, but they are all for when the query is based on a table, or range of data that I can view in excel.

I don't technically have a primary key for that, but one of the column is a W.O generated by our ERP so they are all unique.

Thank you!

Answer 1

I have seen multiples posts and videos with how to do it, but they are all for when the query is based on a table, or range of data that I can view in excel

What you seem to miss: Excel is a Data Source, SQL is a Data Source, Access is a Data Source, a CSV is a Data Source, your ERP (if you have the appropriate Connector) is a Data Source... If all the blog posts and videos you saw use Excel as a Data Source it's probably because it's easier to illustrate a Table in Excel than a Table in i.e. SAP

I don't technically have a primary key for that, but one of the column is a W.O generated by our ERP so they are all unique

No idea what W.O is but as long as this field allows to uniquely identify records you can make it work