Skip to main content

Power BI

New

Dataflow Query Check Warning / Yellow Result

Vote (4) Share
Justin Baity's profile image

Justin Baity on 22 Mar 2023 17:46:44

When saving a dataflow in Power BI service, it runs through 3 checking steps for each loaded query. The results are always either green and the save operation completes, or red and it fails. The problem is that one of those checks has the potential to clean up your queries, adding column type changes or outright deleting columns. When this happens, the result is still a green check with no indication of a change. Unexpected behavior may result and it may not be easy to even find where the change took place on larger dataflows.


I would like a yellow-check warning that something happened and to choose to allow it or go back to the editor, similar to how Excel will sometimes suggest a closing parentheses on an incorrectly typed formula.