Why can't I replace blank cells with null in PowerBI query

[Loveflora1229]

Dear all,

        I was following the step regarding replace blank cells with null but I don't understand why nothing changes? I will attach the screenshop below. Thank you. 

ps: there is indeed 'a space' in the 'value to find' section. 

[Loveflora1229]

thanks! that works!

[watkinnc]

Try using Replacer.ReplaceText instead of Replacer.ReplaceValue.

--Nate

[Alf94 · Accepted solution]

Hi @Loveflora1229 ,

Try not to put spaces in the "value to find" section. Does this work?

If I answered your question, please mark my post as a solution.

Best,