I have the following challenge:

I connected to another spreadsheet that's located in OneDrive/Sharepoint using the Queries/Connections option (Data/Get Data/Sharepoint Folder).
I authenticated with my account which has access to that secondary spreadsheet.
This external spreadsheet has hundreds of columns but I just need a few of them to perform my analysis.

What would be the best way to limit/hide the secondary spreadsheet columns that I don't need so that when I share it with other people that shouldn't have access to all that data they won't be able to see it?

I was thinking:

1. Perhaps I can create an intermediate spreadsheet that has only the fields I need and then connect to that. This way even if people that I'm sharing it with can see the data, it's only the minimal fields needed.
or
2. Create an additional tab in the secondary spreadsheet with only the fields I need and limit the connection just to that tab. Is that even possible?

3. Something else that you have in mind.

Thanks!