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 yesterday should be archieved in the model, because it's not going to change.
- Data from today should be refreshed through Direct Query.
To do so, I've seen that this option is available in PowerBi:
So I've enabled option "Get the latest data with DirectQuery" to achieve my objective, this is: retrieve real-time data with Direct Query. And this works for the current day, but tomorrow (I have checked this) my visualization won't show data for the current day (this is, tomorrow). Am I forgetting anything? Why is my data being retrieved correctly for the current date but, tomorrow, my visualization won't show anything?
Is there an option in PowerBI to keep some past data and only get today data through Direct Query ?
Thanks for your help.