I have two workbooks tracking the same data with different privacy levels and want the second table table to only pull in certain columns from the first one

For context, I work on an HR-adjacent team and am trying to pull in only certain columns that are appropriate for my team to have. I’ve tried Power Query and it seems to work but I run into errors.

I can’t use the “web link” import for some reason (my guess is permissions). I created a workaround of creating a new tab with the PQ table, and then used that table to pull into a new sheet through connections. I’ve also tried to just use a formula on the PQ table in a new workbook but it looks blank unless the main sheet is open.

I’m wondering if there’s a better solution? Right now the two tables exist in different SharePoints with different permissions—might that be the issue? The problem is that a lot of these files that may be in the folder are not appropriate for my team to have access to. 🙃