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 am trying to do incremental refresh based on file name (.csv files) from sharepoint. It's a sharepoint folder where we have all the files in this format "monthly_cost_hourly_2021-01, monthly_cost_hourly_2021-02 etc.,". I want to retain last two years of .csv files but refresh runs only for current month. Do you've anything handy based on my requirement?
Regards,
Laiq
Solved! Go to Solution.
Yes, give this video a look.
https://www.youtube.com/watch?v=IVMdg16yBKE&ab_channel=HoosierBI
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
HI @KNP
It works perfect. Thank you so much. Any chance if we can do the same in dataflow. It's asking datetime field should exist while configuring incremental load.
Regards,
Laiq
You'll need to convert your date field to a datetime, or duplicate it and convert to datetime so you have a field to configure the IR policy on.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Yes, give this video a look.
https://www.youtube.com/watch?v=IVMdg16yBKE&ab_channel=HoosierBI
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Incremental refresh doesn't work for sharepoint or CSV. Think about switching to another data source that supports incremental refresh.