Nulls and blanks handled inconsistently in dataflows Power Query editor

Hi Anonymous ,

Yes, both statements are correct. This issue was reported to me by one of my users and I've been able to reproduce it successfully by creating a linked entity against their source dataflow (which extracts data from an API). I tried to reproduce from scratch by setting up my own simple dataflow with a user input table, creating a linked entity to that in a separate dataflow, then doing the replacements but not getting the same results (i.e. downstream entity is showing tables as expected).

Unless you have any further ideas I may need to investigate further when I'm back at work in a couple of days.

Thanks

Josh