Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have dataflow that does a simple replace for blank values on a text column from a linked entity (in a premium workspace). When I use the below formula, the replacement displays as expected in the Power Query editor:
Table.ReplaceValue(#"Removed columns", "", "No modules", Replacer.ReplaceValue, {"Modules"})
However, when consuming this dataflow table in a downstream object, the replacement hasn't happened:
I tried replacing null, which does not do the replacement in the Power Query editor:
Table.ReplaceValue(#"Removed columns", null, "No modules", Replacer.ReplaceValue, {"Modules"})
But in downstream objects, the replacement has happened:
We have tried using the ReplaceText function instead, it doesn't replace "" in either, and throws a type conversion error when trying to convert null (as expected).
We have tried using an if statement to see if the problem is with the Replacer class, but seen the same results (replace null does not replace in editor, but does so in downstream object; replace "" does replace in editor, but doesn't in downstream object):
Table.AddColumn(#"Removed columns", "NewModules", each if [Modules] = "" then "No modules" else [Modules])
It appears that the display value in the Power Query editor is not consistent with whatever is stored in the dataflow once it is refreshed. It also doesn't make sense that a transformation on null works in the refresh given that the column is formatted as text, for which null is not a valid value. I believe the output of the Power Query editor should reflect what is stored when the dataflow refreshes.
This behaviour does not replicate when referencing a normal table in the query rather than a linked entity.
We are using the below versions:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @JoshT
Thanks for your feedback! No other users have reported similar issues so far, so there are a couple issues I need to double check.
1. If your dataflow related to a normal table , "" can work both in Power Query and downstream object , right ?
2. If your dataflow related to a linked entity , you used "" , it worked in Power Query but not in downstream object . You used null , it worked in downstream object but not in Power Query , right ?
Best Regards,
Community Support Team _ Ailsa Tao