I have a excel query set up which takes CSV files from a folder and runs a function on each to transform and format them individually, I then use table.combine to join all these tables into a single table within this (connection only) query.

I then have two other queries that reference the initial query where they each filter the [selection] column for different values and then pivot the [header] and [value] columns into multiple columns.

The reason I need to split these into two queries is so that I can use Dax Studio to export them to two separate csv files which will later be reference by a data model.

At the moment when I update the queries they both run at the same time and it appears that the initial query is run twice. Can anyone advise of a way I can make this more efficient?