So I simply take one Workbook (which contains many worksheets) and in step 'Navigation' I just select the one named "MSTN Materials", but as described above, it reads many other sheets of the same workbook. How to avoid that?

Re: Power BI loading unwanted worksheets on refresh

This is not the case. As I tried to explain before, I'm not trying to exclude a single query from refresh (or refresh just single query).

I have a query like below:

So as you can see it's a single query with multiple transformation steps. It reads data from Sharepoint folder, currently there is a single file in that folder. This excel file contains multiple worksheets, among which I want to read data from only specific one ('MSTN Materials"). Full list is:

To get to the worksheet, I use "Invoke custom function", which has following steps of transformations for Sample file:

and then the Sample file is transformed as follows:

As you can see, second step there "navigates" to a single sheet, which is "MSTN Materials", but once refreshing, Power BI goes through each and every sheet in that file instead through only this one. So my question is how to force Power BI to read rows only from "MSTN Materials" instead.