Default Date Range

OdataLink Models have a Default Date Range whose purpose is to filter the records to a manageable amount until filters are applied in Power Query

This is controlled via a Start Date and an End Date

When downloading data via OdataLink, any date filter applied to your Power Query will take precedence over these default values. However, if you do not apply a date filter, these defaults will be used.

The Default Start Date is used to exclude transactions dated prior to this date.

The Default End Date is used to exclude transactions dated after to this date.

You can leave the values blank to not restrict the amount of data download. This will come at the cost of reduced performance.

It's important to note that if a date filter is applied to the OData feed via Excel, Power BI or another client, these defaults will not be used.

How to change the Default Start Date and End Date

To change the models default start date and end date, follow these steps.

1. Click on Models on the menu in the left-hand side;
2. Find the model you want to work on and click View;
3. Select the Settings tab;
4. Click on the Edit Model button;
5. Find the Default Date Range and update the values.

   These dates will apply when no date filters are applied via the OData client.

   You can leave the values blank to not restrict the amount of data download. This will come at the cost of reduced performance.

6. Click Save.

Related Topics

Editing models

Models