Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
😡
Solved! Go to Solution.
Solved: Changed Privacy Level from Combine to Always ignore, but still not working per web service
ok, what's your question?
Why so lot of bugs and how to fix this
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
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
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
I think this happens after last update, this bug appears before only on web, but after update it appears also on desktop
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
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
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.
Regards,
Xiaoxin Sheng
Solved: Changed Privacy Level from Combine to Always ignore, but still not working per web service
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |