Sharepoint Data with Oracle Data

Hello power bi sharks,

i kinda have a complex situation here,
let me explain please...

i have a formula that fire sql statments:

( Sql as text) as table =>

let

   Source = Value.NativeQuery(Oracle.Database(Target_Conn_str, [CommandTimeout = #duration(0,0,40,0), HierarchicalNavigation=true]),Sql)

in

    Source

 then i have queris like this:

 sharepoint_List = SQL_List,
    sql = "
SELECT * FROM ABC."& Target_Category_MarketSet &" WHERE DATAMART IN  (" & sharepoint_List & ")   
  "
, 
 Source = fnOracleNativeQuery(sql),
#"Merged Queries" = Table.NestedJoin(Source, {"SHORT_DESCR"}, MARKETSET_FILTER, {"SHORT_DESCR"}, "MARKETSET_FILTER", JoinKind.LeftOuter),
 #"Expanded MARKETSET_FILTER" = Table.ExpandTableColumn(#"Merged Queries", "MARKETSET_FILTER", {"MARKETSET_FILTER"}, {"MARKETSET_FILTER"})


in
    #"Expanded MARKETSET_FILTER"

Now we have tow sharepoint filer here the sharepoit_list and the table that i used it for join MARKETSET_FILTER that's as well a share point file,

now in desktop to make this work all i need to do to check in the privacy levels always ignore privacy level,

but on the service Ohhhhh.., it's very differenet story, 

first i create the gateway conn with privacy level of none but still didn't work, so i found i must buffer my list and so i did,

still didn't work, then i read i must use a staging query of the buffered list, still didn't work, 

i buffered even the buffer!

is there a way to make sharepoint file load first before oracle?!!!

that my SQL_List query and it's buffered from a another buffer :

let
    Source = List.Buffer(Tables),

    SQLList =
        Text.Combine(
            List.Transform(Source, each "'" & _ & "'"),
            ","
        )
in
    SQLList

Tables here as well is buffered in a seprate query that is buffered from source sharepoint file.