Forum Discussion

bjo7000's avatar
bjo7000
Frequent Visitor
5 years ago
Solved

Power bi

When I edited the query and apply changes to thr desktop, the label of the new column I created is present but the data that was created are all empty(grey background). What is going on here?
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, bjo7000 

     

    As is suggested by PhilipTreacy , you may go to 'Query Editor' and check the last step of your query. I tested with two custom columns. 'Custom1' is filled with "" and  'Custom2' is filled with null.

    = Table.AddColumn(#"Changed Type", "Custom1", each "")
    = Table.AddColumn(#"Added Custom", "Custom2", each null)

     

     

    When we edit the query and apply changes to thr desktop, the label of the new columns are present but the data are all empty. Please check if the new column has data in the last step of the corresponding query.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, bjo7000 

 

As is suggested by PhilipTreacy , you may go to 'Query Editor' and check the last step of your query. I tested with two custom columns. 'Custom1' is filled with "" and  'Custom2' is filled with null.

= Table.AddColumn(#"Changed Type", "Custom1", each "")
= Table.AddColumn(#"Added Custom", "Custom2", each null)

 

 

When we edit the query and apply changes to thr desktop, the label of the new columns are present but the data are all empty. Please check if the new column has data in the last step of the corresponding query.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.