Difference between revisions of "Default Date Range"

Default Date Range (view source)

353 bytes added , 22:13, 30 July 2023

no edit summary

3,244

edits

@@ Line 1: / Line 1: @@
-The 'Default Start Date' and 'Default End Date' reduces the amount of transactions data downloaded via the endpoints.
+== Overview ==
-Leave blank to not restrict the amount of data at the cost of increased performance.
+The '''Default Date Range''' reduces the amount of transactions data downloaded via the endpoints.
-'''Default Start Date'''
+This is controlled via a '''Start Date''' and an '''End Date'''
-Excludes transactions dated prior to this date.
-'''Default 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.
-Excludes transactions dated after to this date.
-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.
+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.