Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Stuck with incremental refresh with direct query

Hi,    I'm struggling with a table in my report. This table is a fact table that stores data from 01-01-2023 until today. I'd like to retrieve data this way:    - All data from 01-01-2023 until y...
Need Help
ppm1's avatar
ppm1
Solution Sage
3 years ago

What you've described should work. Your direct query partition should be greater than or equal to today (the RangeStart parameter for that latest partition). How did you set up the filter in your query with RangeStart and RangeEnd?


Pat

  • YukiK's avatar
    YukiK
    Impactful Individual
    3 years ago

    I second this. DirectQuery option will be from today/effective day onwards. It's good to check all the settings