Not able to select sheet while loading data to query

[Amardeep100115]

I am not able to select file while combining file in one table Please advice.

[Anonymous · Accepted solution]

Hi @Amardeep100115 ,

Yes, you can't do custom on navigation menu when you choose combine option.(it only support to generate some simply M query code)

In my opinion, I think you need to enter to query editor and manually modify your query step formulas.(add a custom filter steps to query table before expand table steps)

Regards,

Xiaoxin Sheng

[Amardeep100115]

Got you