topic Re: Formula.Firewall bug in Developer

Formula.Firewall bug

Analitika — Thu, 31 Dec 2020 15:44:43 GMT

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

😡

Re: Formula.Firewall bug

lbendlin — Thu, 31 Dec 2020 17:07:15 GMT

ok, what's your question?

Re: Formula.Firewall bug

Analitika — Sat, 02 Jan 2021 13:10:32 GMT

Why so lot of bugs and how to fix this

Re: Formula.Firewall bug

Anonymous — Mon, 04 Jan 2021 01:59:56 GMT

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

Re: Formula.Firewall bug

Analitika — Mon, 04 Jan 2021 06:07:02 GMT

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

Re: Formula.Firewall bug

Anonymous — Mon, 04 Jan 2021 07:29:46 GMT

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

Re: Formula.Firewall bug

Analitika — Mon, 04 Jan 2021 07:58:39 GMT

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

Re: Formula.Firewall bug

Anonymous — Tue, 05 Jan 2021 02:29:42 GMT

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

Re: Formula.Firewall bug

Analitika — Tue, 05 Jan 2021 09:23:25 GMT

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

Re: Formula.Firewall bug

Anonymous — Wed, 06 Jan 2021 01:54:35 GMT

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

Re: Formula.Firewall bug

Analitika — Thu, 07 Jan 2021 18:53:00 GMT

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