Power Bi - Replicon

[rosscoy]

I'm currently using Power Bi to visualise information from Replicon (a time sheet system). But unfortunately, due to the large size of the data coming from Replicon, it can take quite a while for the data to refresh.

Is there any way to reduce the or filter the data coming from Replicon so that it only pulls in data from 2022 onwards or something similar to that?

Currently my Power Bi Advanced Editor settings for the TimeEntry table from Replicon looks like this:

The column I would like to filter (in the hopes of reducing the overall time to load the data from Replicon) is the EntryDate column, but I'm option to other methods if this wouldn't be the optimal one.

Thanks in advance.

[DataInsights · Accepted solution]

@rosscoy,

You could apply a filter to EntryDate by clicking the dropdown for EntryDate and specifying a filter:

Ideally, the filter would be pushed upstream to Replicon (query folding) so it extracts only the desired rows from Replicon, instead of extracting all rows and then removing the unwanted rows in Power Query.