Forum Discussion
Query Folding dissable after using filter - ODBC - Postgresql Unicode
Hi kamilos01 -Yes, the issue you're facing is most likely due to query folding breaking when you apply a filter using RangeStart and RangeEnd in Power Query.
as checked the steps, bfore merging, apply the date filter as early as possible.This ensures filtering happens before merging.If the View Native Query option remains greyed out, then filtering is happening locally. in someways, Instead of merging in Power Query, try joining tables in PostgreSQL first and then importing the result.
Hope the above information helps.
Hi rajendraongole1
Thanks for your suggestions. Yes, I was trying to filter out as early as possible (including other columns), but always "View native query" was greyed out.
Initially I wanted to use join in my postgresql DB earlier, but simple table was too big to get it and I always got an error.
Hi kamilos01 -Yes, the issue you're facing is most likely due to query folding breaking when you apply a filter using RangeStart and RangeEnd in Power Query.
as checked the steps, bfore merging, apply the date filter as early as possible.This ensures filtering happens before merging.If the View Native Query option remains greyed out, then filtering is happening locally. in someways, Instead of merging in Power Query, try joining tables in PostgreSQL first and then importing the result.
Hope the above information helps.
Hi rajendraongole1
Thanks for your suggestions. Yes, I was trying to filter out as early as possible (including other columns), but always "View native query" was greyed out.
Initially I wanted to use join in my postgresql DB earlier, but simple table was too big to get it and I always got an error.