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.
Hi all!
I have a impala datasource with a huge table that just contains a date column for year-week 'YYYY-WW'.
Is there any chance to implement an incremental refresh in here?
Hi @joshua1990 ,
Is your problem solved? If so, would you mind accept the helpful reply as solution? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!
Best Regards,
Community Support Team _ kalyj
If your YW column had YYYYWW and was an integer, you could just follow the approach shown in this video.
Incremental Refresh with Integers in Power BI - YouTube
Since it is a text format, a different approach is needed (same basic steps as in video, but different logic). You can use a query like this, which still folds back to your database (at least it did with SQL Server). You need to create the RangeStart and RangeEnd paramaters with DateTime type first and the YYYYMM_List step generates a distinct list of the YearMonths (use same approach for YearWeeks), and then List.Contains in the filter will fold back to your source to only incrementally load the proper YearWeek rows.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.