Incomplete Data Load Results

[jianne_devilla]

There are times when the query results don't match the actual data being loaded into the dashboard. This inconsistency has been affecting the accuracy of the reports. Please see below screenshot for reference:

Query Results: 144,737

Total Number of Rows: 130,495

Do you have any idea how to fully load the 144,737 rows?

[rwunderlich]

Without seeing more of the script, it's hard to give an opinion. Is there a preceding load before the SQL Select? Is there a subsequent script statement(s) that operates on the GPSdata table?

-Rob

[paolo_cordini]

Check section access....

[jianne_devilla]

I tried commenting out the Section Access, and it worked. However, I need it enabled to properly manage user access. Please see below script:

Can you tell me what caused the issue here?

[paolo_cordini]

Without knowing the data model, is difficult...

Some values of KEY are filtered out by the section access. Maybe there are some NULL values in the field KEY? It should be not difficult to spot the missing KEY values because they will appear without section access