Forum Discussion
Solved
How to dynamically import data based on last two years - Date ID
My organization uses a SQL data warehouse and uses direct import into Power BI. We have date IDs in our Date dimension table. For instance, 6300 is March 31st, 2025. Our fact tables are getting large...
If you use incremental refresh you can set a range of data to be imported, within this range you can specify what data is not refreshed but is kept in the model, with only the most recent data being imported, but with older data still being accessible to the report
Deku
Super User
Super UserIf you use incremental refresh you can set a range of data to be imported, within this range you can specify what data is not refreshed but is kept in the model, with only the most recent data being imported, but with older data still being accessible to the report