Power bi

[bjo7000]

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?

[v-alq-msft · Accepted solution]

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]

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.