Formula.Firewall bug

[Analitika]

WTF?  why my all function converted today to 

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

Everything works fine till today, no changes have maded by me

😡

[lbendlin]

ok, what's your question?

[Analitika]

Why so lot of bugs and how to fix this

[Anonymous]

Hi @Analitika,

You can take a look at the following blog about the power query firewall error reference issue:

Power Query Errors: Please Rebuild This Data Combination 

Regards,

Xiaoxin Sheng

[Analitika]

But better, you should read carefully my post, to understand what i asking to.

Everything works fine till today, no changes have been maded by me

[Anonymous]

HI @Analitika,

Yes, I saw your notifications before I replied. I'd like to suggest you take a look at the blog to confirm if these operations that the blog mentioned also include in your report.

Where are these messages display? Desktop or service side?

If you are work on the desktop side, did you update your power bi desktop recently? (desktop update may include some new release on the query editors or notifications)

If you are working on power bi services side and these reports work normally in the past, they can also be caused by internal or backend processing of power bi service.

How to Get Your Question Answered Quickly 

Notice: these notifications may not be displayed immediately when you add them to your query steps.

Regards,

Xiaoxin Sheng

[Analitika]

I think this happens  after last update, this bug appears before only on web, but after update it appears also on desktop

[Anonymous]

HI @Analitika,

In fact, this notice does not mean the bug, it works as expected.
It means power bi increase the security levels of 'data privacy' so that power bi will check all the queries and their steps to confirm if your queries existed similar operations.

You can take a look at the following link to change the data privacy settings to fix this issue.

Power Query – Common Errors & How to Fix Them 

Power BI Desktop privacy levels 

Privacy Levels for Cloud Data Sources 

Regards,

Xiaoxin Sheng

[Analitika]

In fact this is a big bug, as i dont ask to check my security levels, and dont ask to crash all my projects, and also i dont want to fix anything done by your developers

[Anonymous]

Hi @Analitika,
OK, you can consider open the ticket to direct contact the power bi team to report this scenario to help them confirm and fix this sceniaro.

Support MS Power bi 

submit a support ticket

Regards,

Xiaoxin Sheng

[Analitika · Accepted solution]

Solved: Changed Privacy Level  from Combine to Always ignore, but still not working per web service