Forum Discussion

leehbi99's avatar
leehbi99
Frequent Visitor
7 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
    7 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.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 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.