Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I set up incremental refresh on a dataset with about 3million records. I set the incremental refresh to work on 1 of the 18 months in the dataset. Everything works, but it actually takes longer to refresh now, which is odd. The refresh of the whole dataset (before) was about 3 minutes, now after it's all setup, after the initial refresh, it's around 17 minutes. I can't wrap my head around how this can be. Maybe incremetnal refreshes don't help for all datasets, only very, very large. Odd that I can't benefit from from this long awaited feature.
Any Advice on this?
Hi Team,
I use Power BI premiuim and and after implementing incrimental refresh the refresh takes more time than normal refresh.
i need to store 2 month data ( current + last month) and refresh only current month data.
daily insert will be approax : 6 lakhs records. can you suggest me what needs to be done to get refresh faster
I hear you on the 3 minute refresh. I was eager to use this to save some time. It's a big feature that I've been waiting a long time for. There's always a more efficient solution. I've got 100's of users using datasets, so I hate tying up the back end of the Vertipaq engine with reloading millions of stale data, potentially impacting performance. It seems inefficient on both a system resource and time perspective.
Whatever the driver, it's extremely odd that incremental is slower than the full refresh. Seems like total non-sense to me. hopefully it's a bug that they'll address before making it GA in Premium. I personally find it Disapointing. I'm glad it helps out people running massive datasets though.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.