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've got a composit fact table made from 3 appended (unioned) tables
I need to configure an incremental refresh on this appended fact table that reloads the last 10 days of sales data, but allows future data for budget and forecasting and always refreshes the inventory snapshot. All use the same YYYYMMDD date key
Worst case, I could write a union query at the source so I'm only dealing with a single entity in m-query, but I'm still left trying to allow for future dates in budget and forecasting records.
Is this possible? Has anyone done this before? I really don't want to have to re-define the data model to use individual fact tables. Any ideas?
Thanks all
@BillColeman , Have tried incremental refresh using date key, suggested in this blog
Can you use DAX append for Past data
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
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.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |