Merge queries

[Orlovaaaa]

Hello everyone! I tried to merge queries but got the following notice:

"Formula.Firewall: Query 'DealsHubSpotHistory' (step 'Merged Queries') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

What does this mean? What should I do?

[rubayatyasmin]

Hi, @Orlovaaaa 

Sometimes, setting the privacy level to "Ignore the Privacy Levels and potentially improve performance" can resolve the issue, but be cautious as this may have implications for data security.

these links may help you. 

https://community.fabric.microsoft.com/t5/Power-Query/Query-references-other-queries-or-steps-so-it-...

https://community.fabric.microsoft.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so...

https://exceloffthegrid.com/formula-firewall-in-power-query/

[Orlovaaaa]

Thank you very much for your reply, I will take a look at the links that you so kindly shared with me. Hope to find a solution soon.