Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I've my report connected to the Oracle Database, I have set up all my RangeStart/End and incremental refresh. I want to only imported dataset starting from 01/01/2023 to YTD - no data from 2022, and I am wondering what and how I should set it up in my incremental refresh setting. I am currently set the archive data starting 3 months from refresh date and incremental refresh 20 days - which will imported my data from 01/01/2023. But by doing it I have to constantly going back to change the setting and refreshing it - this may take up a lot of time everytime I change the setting. I was wondering is there a way we can set a specific start date for import data and they will do the incremental refresh starting from that specific date, in my example is 01/01/2023. Thank you in advance.
Nothing stops you from adding another date filter to your query (in addition to RangeStart/RangeEnd). You may end up with a couple of empty partitions but that should be acceptable.