Forum Discussion

leehbi99's avatar
leehbi99
Frequent Visitor
6 years ago
Solved

Loading dataflow converts null to empty

I have a dataflow that is connected to an Oracle table.     Dataflow works okay, there is a null value in one of the rows.   The data preview for the dataflow shows this as (null) All good.    When I...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi

    As tested, if the column is of text type or contains many types, when connect to dataflow with Power BI Desktop,

    These columns show "null" cells as blank cell in Edit queries.

    When loading into data model, all columns regardless of type text, number, date,,ect, would show "null" celss as blank cell.

    To solve it, select teh columns, replace blank cell with "null",

    If the UI doesn't work, please change the code with "null" as below.

     

    Best Regards

    Maggie

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi leehbi99 ,

I tried this in a text column, and a numbers column. The number column will only replace with a number like 0 if I use a find and replace. The text column will replace with null. Not sure that is your problem. If checking the column type does not work, try ImkeF who knows all the back doors in M language.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel