Forum Discussion

Giel0's avatar
Giel0
Frequent Visitor
3 years ago

Filter on date column with SQL ibm db2

Hi,   I have a large table which I would like to filter dynamically based on a date column. I have an orderdate column which has the format  YYYYMMDD from the IBM db2 database.  However, if I woul...
Need Help
Giel0's avatar
Giel0
Frequent Visitor
3 years ago

Hi alosada ,

 

Thanks for your response. Loading the whole table and make transformations in the Power Query editor works. However, the reason for the SQL query is because it is a large table while I only need a small part of it. So importing the whole table gives me a lot of data which I do not need and could potentially lead to performance problems. 

 

So to make the data load as efficient as possible I would like to query on the small part I of the data in the table I need.

 

Is there any way to use SQL to exclude the rows which cause this error?

  • alosada's avatar
    alosada
    Frequent Visitor
    3 years ago

    Hello Giel0 ,

     

    I don't think there's a way to use SQL to exclude the error rows, but here what I would do is filter the data that you need to keep with an SQL query and then trying to apply changes in PowerBI and see its behaviour.