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
As highlighted by rohit1991 and rajendraongole1 , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.
Thanks,
Cheri Srikanth.