get resource hours planned by day

Using project server 2019 Subscription edition.

We have published several projects with tasks and resource assignments.

But in a sql query:

select * from pjrep.MSP_EpmAssignmentByDay

we get no data.

why?

In project server desktop app, we can see work in the resource use view correctly