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.

     

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi bjo7000 

Whatever the last step in your query is doing has yielded no data or empty strings.

Apart from that, it's impossible to give more detail without knowing what your query is doing.  Can you please share it.

Phil

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

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.