Default Date Range - Revision history

Jeff at 01:34, 23 February 2025

2025-02-23T01:34:42Z

← Older revision		Revision as of 20:34, 22 February 2025
Line 1:		Line 1:
	[[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~~		[[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.		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.

2025-02-23T00:32:47Z

← Older revision		Revision as of 19:32, 22 February 2025
Line 1:		Line 1:
	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		[[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'''		This is controlled via a '''Start Date''' and an '''End Date'''

2025-02-23T00:32:32Z

← Older revision		Revision as of 19:32, 22 February 2025
Line 1:		Line 1:
	A [[~~Model~~]] ~~has~~ a '''Default Date Range''' whose purpose is to filter the records to a manageable amount until filters are applied in Power Query		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'''		This is controlled via a '''Start Date''' and an '''End Date'''

2025-02-23T00:31:16Z

← Older revision		Revision as of 19:31, 22 February 2025
Line 1:		Line 1:
	~~The~~ '''Default Date Range''' ~~reduces~~ the amount ~~of transactions data downloaded via the endpoints.~~		A [[Model]] has 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'''		This is controlled via a '''Start Date''' and an '''End Date'''

2025-02-03T22:17:44Z

← Older revision		Revision as of 17:17, 3 February 2025
Line 24:		Line 24:
	# Find the [[Default Date Range]] and update the values.		# Find the [[Default Date Range]] and update the values.
	#: These dates will apply when no date filters are applied via the [[OData client]].		#: 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'''.		# Click '''Save'''.

2025-02-03T22:17:19Z

@@ Line 14: / Line 14: @@
-== Related Topics ==
+= How to change the Default Start Date and End Date =
 :[[Editing a model's details|Editing models]]
 :[[Models]]

2024-05-03T04:38:22Z

← Older revision		Revision as of 23:38, 2 May 2024
Line 15:		Line 15:

	== Related Topics ==		== Related Topics ==
			:[[Editing a model's details\|Editing models]]
	[[Models]]		:[[Models]]

2023-07-31T03:15:03Z

← Older revision		Revision as of 22:15, 30 July 2023
Line 12:		Line 12:

	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.		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 ==		== Related Topics ==

	[[~~Model~~]]		[[Models]]

2023-07-31T03:14:56Z

← Older revision		Revision as of 22:14, 30 July 2023
Line 12:		Line 12:

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

2023-07-31T03:14:40Z

← Older revision		Revision as of 22:14, 30 July 2023
Line 1:		Line 1:
	~~== Overview ==~~

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