Forum Discussion

CuriousKoala's avatar
CuriousKoala
New Member
1 year ago
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...
  • Deku's avatar
    1 year ago

    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