Add column to display name of data source

[phull543]

Hello, I need to identify the data source in a table because I am going to append queries and combine all the queries listed on the left into one table. So I want to implement a column to identify each data source so that when I am displaying the appended querie in one table I can filter that table by brand name. So for example I have a query called CRENDON, I need to add a column that identifies it as such. All help is appreciated. 

[BA_Pete]

Hi @phull543 ,

There's no OTB way to do this in Power Query.

If your queries are fixed on those brands, then I'd suggest either:

In Power Query add a new custom column:

= "CRENDON"

...or in the native query:

SELECT *, 'CRENDON'
FROM ~

Pete