Historical data runchart

[BluSonic]

Hello community,

i´m setting up a report for a ticketing-system. power bi is connected directly to the SQL database of the ticketing-system.

i´d like to realize a kind of a historical runchart. for example: every day at 11:00pm an automatical data-dump should be made, so i will be able to create a runchart were i can see the amount of tickets at 11:00pm from yesterday, the day before yesterday etc.

How is this possible in power bi?

Regards