How to run the power query applied steps on specific data only?

[Anonymous]

Hi all,

Is it possible to run the applied steps in the power query that Ive written, on specific data only? Im talking about the steps below, which is basically a script to transform combination products into single products. The problem is that I still have to apply this to my original data sheet, but I want the steps to apply to a single administration only.

I can't split the original data into multiple folders (seperate queries), because it would be too much work to do, and eventually we'll have a direct sql connection with the database. Right now all the data is stored in one excel sheet.

Example:

Data Sheet = Administration A + Administration B + Administration C + Administration D

The applied steps should only be applied to Administration C, is it possible to use a filter for the applied steps? (using an If statement somewhere?)

[v-juanli-msft]

Hi @Anonymous 

Please show an example data and what steps needed to be done as an example.

From your information, it still not clear how "Administration A" lies in the table.

Besides, from this information:

"I can't split the original data into multiple folders (seperate queries), because it would be too much work to do, and eventually we'll have a direct sql connection with the database. Right now all the data is stored in one excel sheet." 

It seems your data source is an excel file, then you connect to excel file with Power BI Desktop, right?

Best Regards

Maggie