Forum Discussion
Filter date with ODBC database
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.
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.