Filter date with ODBC database

[giuliapiazza94]

Hi guys,

I need to filter the rows that I want to import from ODBC database with a range of dates (for example 01/01/2019 - 31/12/2021)

I have created the parameters but I don't know how connect the sales table with the parameters like when I use sql server.

Have you a idea?

thank you all

[v-jingzhang · Accepted solution]

Hi @giuliapiazza94 

You can connect to the database first and get preview data in Power Query Editor. Create two query parameters of date type, e.g. startDate and endDate. Then click the down arrow on the date column header to expand the menu and select Date Filters > Between. Select two parameters for the range start date and end date.

If you want to use native database query to query and filter the data, you can expand Advanced options on the connection window, enter query into the SQL statement (optional) box. You can input two definite dates to filter data first. Then in Power Query Editor, use query parameters to replace the date values in original SQL statement.

Both operations are similar to that when you use SQL Server.

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