Source sheet and Report access


I have a sheet with lots of records.

I created a report from the that sheet and condition is if its matching to current user then they can see the rows in report and edit.

but if those user does not have access to the source sheet they can't see the rows in the report.

is that expected?

if yes then how to restrict the user not to see or edit source sheet but only report sheet?