Default Date Range: Difference between revisions
No edit summary |
No edit summary |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[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. | ||
| Line 24: | Line 32: | ||
# 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'''. | ||