Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
Proud to be a Datanaut!