Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

filter by date without losing query folding

Hi all,    I am using the HANA connector in import-mode to import a table which has a date-column. I want to filter the query based on this date-column, however it's not formatted as dates. I could...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    Changing the data type of a column in Power Query Editor will break query folding, so please delete the "Changed type" step. Then you can try Anonymous 's suggestions. If your date column in the data source is in number data type, filtering will not break query folding. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

Changing the data type of a column in Power Query Editor will break query folding, so please delete the "Changed type" step. Then you can try Anonymous 's suggestions. If your date column in the data source is in number data type, filtering will not break query folding. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.