Privacy - Firewall error; rebuilding query requirement

If Power Bi is sensitive about a query that I've joined with an API to a public source, how do I clean that query and keep my privacy settings.  While the query may have eventually started with sensitive data (initially sourced from an internal dbase), it's been cleaned/filtered to only include Ticker symbols and descriptions so nothing that should be overly sensitive to pass on.

Is there any way of copying this clean data (tickers/descriptions) to a clean table and Power BI be willing to pass this through?

When I turn privacy off for file, the query runs without issue.

All assistance appreciated.