Section Access Along with a partial reload

[Shouq]

Hello I want to implement a partial reload for my application. I want to only reload the section access every evening.  Partial reload works but I don't think it refreshes the access. This is how I tested it: I gave myself access, did a full reload, all normal. Then took away my access and did a partial reload and I still had access. 

This is my code:

section access;

Let vLastReloadMode = If(IsPartialReload(), 'Partial', 'Full');

Replace LOAD

'ADMIN' as ACCESS,

    if(MEG = 1, 'REDACTED\'&Upper(SapUser)) as USERID

FROM [lib://REDACTED/EmployeesFunction*.xlsx]

(ooxml, embedded labels, table is Sheet1)

where 1=1;

Concatenate

SecurityScheduler:

Load * Inline 

[ ACCESS, USERID

ADMIN, INTERNAL\SA_SCHEDULER];

section application;

[Qrishna]

when section access file has changes, do a full refresh and not any partial loads as with the latter  theres always connections to other datasets/tables. that wont be refreshed/relations wont be refreshed.

[Shouq]

@Qrishna Thank you for the reply. Does this mean that there is no way of applying a successful partial reload to a section access?

[Qrishna]

technically you can but most of the time we encounter with issues like not proper data reduction etc. in your case i believe the section access tables is not completely replaced by the new one.  Try below:

Section Access;
LOAD * INLINE [
ACCESS, USERID
];

If IsPartialReload() Then
//Replace the section access table with the new data if partial reload
Section Access;
SecurityScheduler:
Load * Inline
[ ACCESS, USERID
ADMIN, INTERNAL\SA_SCHEDULER];
CONCATENATE(SecurityScheduler)
LOAD 'ADMIN' as ACCESS,
if(MEG = 1, 'REDACTED\'&Upper(SapUser)) as USERID
FROM [lib://REDACTED/EmployeesFunction*.xlsx]
(ooxml, embedded labels, table is Sheet1)
where 1=1;
Else
// Full Reload
Section Access;
Load * INLINE [
ACCESS, USERID
ADMIN, INTERNAL\SA_SCHEDULER];
End If;

Section Application;

EXIT SCRIPT;

i havent run this script as i dont have any sample data to test. so let me know how that goes with code above.