Forum Discussion

robarivas's avatar
robarivas
Post Patron
9 years ago

Why no Query Folding?

In Power BI Desktop I am connected to an IBM DB2 database for the first time and when I run a simple filter on a date column in the table I do not get any Query Folding. So the filter takes an indefi...
Need Help
robarivas's avatar
robarivas
Post Patron
9 years ago

Hello Anonymous. I confirmed that Query Folding occurs when filtering most fields, which is good. However, it is specifically with Date and Date/Time fields that the Query Folding stops. And even with Date & Date/Time fields it will work if I choose (checkmark) particular dates. But if I filter for a range of dates (using After, Between, Before, etc.) then the Query Folding stops working.

 

Oh and by the way I (so far) have only noticed this on one of my largest tables in my database (i.e., my "sales" table). On other tables (so far) date filtering does not shut down query folding.  Very strange.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    robarivas,

    I suspect the issue is caused by that there is large amount of data in your table. Could you please filter your data by writing specific statement during the connection and check if the issue persists?



    Regards,
    Lydia Zhang

    • robarivas's avatar
      robarivas
      Post Patron
      9 years ago

      Hello Anonymous

       

      Per your suggestion I generated a small subset of the data using a SQL statement but now no folding takes place at all. Please help. Our transaction table is our most important table. Not being able to query it quickly is a major issue. Thank you.