How do you know that not all data is getting loaded? How did you check this? Did you open your document in QV Desktop using an ADMIN account? Maybe the data gets reduced for everybody.
As a test, add an ADMIN account with empty link fields to your section access table, reload and open your document in QV Desktop using that account.
Note that your observation that all data is loaded when reloading in QV Desktop is correct, because Section Access will only reduce your data model at file open time and never afterwards. So a reload always returns a full data set, until you save-close-reopen the document. At that moment Data reduction is applied on the new data set as well.
Thanks for the answer.
We got a complaint from the user for a particular group , the data is not loading correctly and also when we compare with our DMS application.
Upon further analysis , we tried to manual reload the document with the same service account and the data is loading correctly.
Then we tried the remove the code from the section access code and data was loading correctly when ran from the publisher .
Hence we finalized , it was problem with the section access.
Ok, so you'll have to focus on the way Section Access reduces the data for particular users.
There is an easy and very useful technique to simulate data reduction as far as possible. It simply consists of opening your misehaving document in QV Desktop, commeting out the statement Section Access; and reloading the document. You don't need to close it. Now your data model will contain an extra field called NTNAME (or even NAME). Put this field as a liustbox on a sheet and in this field select the user that is experiencing problems. You are now simulating data reduction as much as possible. Investigate what is happening in your data model.
You will probably find the real cause of this data reduction malfunction.
Do not forget to remove the comment marker after you're done investigating or your document will show everything top everyone.