Forum Discussion
Transform File pulling data from other tab
Basing on just the M Script itself, your query shouldn't be pulling data other than from Final_Payment HW. In fact if you change the item name into something else and it doesn't exist, the query would throw an error.
Below is a screenshot of a typical Source step with an excel file as the data source and the typical M script to retrieve the contents of Table in Data column in the first row would be = Source{[Item="Sheet1",Kind="Sheet"]}[Data].
Now if I changed the item name to just Sheet instead, that would result to an error as Sheet doesn't exist iin column Item.
Basing on just the M Script itself, your query shouldn't be pulling data other than from Final_Payment HW. In fact if you change the item name into something else and it doesn't exist, the query would throw an error.
Below is a screenshot of a typical Source step with an excel file as the data source and the typical M script to retrieve the contents of Table in Data column in the first row would be = Source{[Item="Sheet1",Kind="Sheet"]}[Data].
Now if I changed the item name to just Sheet instead, that would result to an error as Sheet doesn't exist iin column Item.