No Oauth option on service

[EricHulshof]

Hi all,

Im working on a report based on a Projects Online environment. And used the content pack as a headstart. But the content pack is trying to load all data; loading that in took about 17hours.. So i edited the odata string to use some filters like this: 

let
    Source = OData.Feed((#"PWA Site URL" & "/_api/ProjectData/[en-us]/ResourceTimephasedDataSet?$filter=TimeByDay gt datetime%27" & FromYear & "-01-01T00:00:00%27 and TimeByDay lt datetime%27" & TillYear & "-12-31T00:00:00%27"),null, [Timeout=#duration(0,8,0,0)]),
    Selected = Table.SelectColumns(Source,{"ResourceId", "TimeByDay", "BaseCapacity", "Capacity", "ResourceName"}),
    #"Renamed Columns" = Table.RenameColumns(Selected,{{"ResourceId", "Resource Id"}, {"TimeByDay", "Time By Day"}, {"BaseCapacity", "Base Capacity"}, {"ResourceName", "Resource Name"}})
in
    #"Renamed Columns"

So in this case im using parameters to define what year to get from the odata feed. However, when i publish this the option to use oauth on the service dissapears; and i can not automatically refresh the report. But i can login using my org. account on the desktop version.

So the question is; do you experts know a way to not load all data, but still use an oauth connection?