do I have to grant access to the source grid for others to view reports?


lets say I have a sheet with 10 columns. 7 with general information, 3 with sensitive data.

Now I want to share the general information with others. So I create a report with the 7 columns and share it accordingly. The people I´m sharing it with keep saying that they are looking at blank pages. They might see the headers, but no line content.

Do I have to grant access to the source sheet? But this wouldn´t make sense because then they would be able to see the not-selected columns with the sensitive information too.

What am I missing?