Not able to select sheet while loading data to query

[Anonymous]

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

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

[Anonymous]

Got you