Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Not able to select sheet while loading data to query

I am not able to select file while combining file in one table Please advice.    
  • Anonymous's avatar
    Anonymous
    7 years ago

    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