Privacy - Firewall error; rebuilding query requirement

[Wolly]

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.

[cpwebb · Accepted solution]

In most cases yes, you can avoid data privacy errors in the Power BI Service. This video covers pretty much everything I know about the subject and may answer your questions: https://blog.crossjoin.co.uk/2020/06/21/video-power-bi-data-privacy-settings-deep-dive/