Orderdate column is filled, but shows as empty in Desktop

[Victornld2]

UPDATE: the orderdate column was a datetime type column, linked to a date type column of the calender. After changes the type of orderdate column to date type instead of datetime type, the small issue was solved. 

---

Hi everyone!

I got a weird problem. 

I've got a orderdate column which is filled. But the 'Column Quality' shows as 100% empty, and when I transform and load the data into desktop, it also doesn't show any data in a visual. 

The first picture is in PowerQuery, the second is the Data view in Desktop and the third is the same data in a visual in Report view.

Does someone has the key to solve this? Or an idea what the problem might be? 

[v-stephen-msft]

Hi @Victornld2 ,

When you go back to Power BI Desktop from Power Query, did you click 'Close&Apply' in Power Query?

Only when you click, your data in PQ will be applied in Desktop.

Best Regards,

Stephen Tao

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

[serpiva64]

Hi,

you have posted 2 images of Besteldatum and 1 of Orderdatum

please post the images of Besteldatum in power query

Have you some relationship affecting Orderdatum?

[Victornld2]

Thanks for the heads up. Edited. 

[serpiva64]

You are welcome!

If this post is useful to help you to solve your issue consider giving the post a thumbs up