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.
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.
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.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
