RangeStart and RangeEnd parameters not retrieving all data from Query.

[ZWilkinson]

I have three tables that I am trying to use incremental refresh with. 
These tables are drawing data from application insights. 

To use incremental refresh, I have created the RangeStart and RangeEnd, which I have set to 01/10/2023 and 01/01/2026 respectively. 
The issue I'm having is that the query does not seem to be collecting data from 01/10/2023 for all three tables, it is only working successfully for one of them. 
Within the incremental refresh settings, I have set to archieve data starting from 5 years before the refresh data and incremenally refreshing data also 5 years before the refresh date, though this doesn't seem to change the outcome at all.
I am stuck with data from 27/10/2023 and 01/11/2023 in the two tables that will not update

Interestingly, the tables that will not retrieve data all the way to the RangeStart data are not the biggest tables, and have about 75,000 rows in each.

I therefore am not sure why I am facing this issue. 

Please let me know if you have any insight into this issue, thanks. 

[amitchandak]

@ZWilkinson , Make sure Name are Excatly Same RangeStart and RangeEnd, Data Type is Datetime. 

And Only one side use =

Like <= or >= Not both

[ZWilkinson]

Hi there, 
I am drawing the data from Application insights, so my query looks like this:

let
// Use the parameters in the URL query options
StartDateText = Text.From(DateTime.ToText(RangeStart, "yyyy-MM-ddTHH:mm:ss.fffZ")),
EndDateText = Text.From(DateTime.ToText(RangeEnd, "yyyy-MM-ddTHH:mm:ss.fffZ")),
Url = "https://api.applicationinsights.io/v1/*****url goes here******",
Query = [
#"query" = "pageViews",
#"x-ms-app" = "AAPBI",
#"timespan" = StartDateText & "/" & EndDateText,
#"prefer" = "ai.response-thinning=true"
],
Source = Json.Document(Web.Contents(Url, [Query=Query, Timeout=#duration(0,0,4,0)])),
TypeMap = #table(
{ "AnalyticsTypes", "Type" },
{
{ "string", Text.Type },
{ "int", Int32.Type },
{ "long", Int64.Type },
{ "real", Double.Type },
{ "timespan", Duration.Type },
{ "datetime", DateTimeZone.Type },
{ "bool", Logical.Type },
{ "guid", Text.Type },
{ "dynamic", Text.Type }
}
),
DataTable = Source[tables]{0},
Columns = Table.FromRecords(DataTable[columns]),
ColumnsWithType = Table.Join(Columns, {"type"}, TypeMap, {"AnalyticsTypes"}),
Rows = Table.FromRows(DataTable[rows], Columns[name]),
FinalTable = Table.TransformColumnTypes(Rows, Table.ToList(ColumnsWithType, (c) => { c{0}, c{3}})),
#"Sorted Rows" = Table.Sort(FinalTable,{{"timestamp", Order.Ascending}}),
#"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"timestamp", type datetime}}),
#"Sorted Rows1" = Table.Sort(#"Changed Type",{{"timestamp", Order.Descending}})
in
#"Sorted Rows1"


I therefore don't know if your comment "And Only one side use = Like <= or >= Not both" applies to this. 

Please let me know, 

Thanks