Default Date Range: Difference between revisions

(7 intermediate revisions by 2 users not shown)

Line 1:

~~The '''Default Date Range''' reduces the amount of transactions data downloaded via the endpoints~~.

[[OdataLink]] has [[Models]].

This is controlled via a '''Start Date''' and an '''End Date'''

A Model is a container to store settings.

One of those settings is a '''Default Date Range'''.

This is controlled via a '''Start Date''' and an '''End Date'''.

When a model is first created it gets allocated a default '''Start Date''' and '''End Date''' within a couple of years.

The intention of these defaults is to keep intial refreshes manageable.

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.

Line 13:

Line 21:

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.

~~== Related Topics ==~~

[[Model]]

= How to change the Default Start Date and End Date =

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

# Click on '''Models''' on the menu in the left-hand side;

# Find the [[Models|model]] you want to work on and click '''View''';

# Select the '''Settings''' tab;

# Click on the '''Edit Model''' button;

# 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.

# Click '''Save'''.

= Related Topics =

:[[Editing a model's details|Editing models]]

:[[Models]]

@@ Line 1: / Line 1: @@
-The '''Default Date Range''' reduces the amount of transactions data downloaded via the endpoints.
+[[OdataLink]] has [[Models]].
-This is controlled via a '''Start Date''' and an '''End Date'''
+A Model is a container to store settings.
+One of those settings is a '''Default Date Range'''.
+This is controlled via a '''Start Date''' and an '''End Date'''.
+When a model is first created it gets allocated a default '''Start Date''' and '''End Date''' within a couple of years.
+The intention of these defaults is to keep intial refreshes manageable.
 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.
@@ Line 13: / Line 21: @@
 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.
-== Related Topics ==
-[[Model]]
+= How to change the Default Start Date and End Date =
+To change the models default start date and end date, follow these steps.
+# Click on '''Models''' on the menu in the left-hand side;
+# Find the [[Models|model]] you want to work on and click '''View''';
+# Select the '''Settings''' tab;
+# Click on the '''Edit Model''' button;
+# 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.
+# Click '''Save'''.
+= Related Topics =
+:[[Editing a model's details|Editing models]]
+:[[Models]]