Default Date Range: Difference between revisions

No edit summary
No edit summary
 
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.