Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Blank date display differences between Power Bi desktop and web (shows 12-30-1899)

Hello,   I'm having trouble viewing blank dates. I created a report in power bi desktop and blank dates appear "blank". But when I publish the report on the web, the same dates appear with the d...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    Depending on your timezone the datetime value balnk corresponds to 1899-12-31 or 1899-12-30. 

    You can try to replace the blank with "null" in Power Query and publish it to the web again to see if the problem still remains.

     

    Best Regards,
    Community Support Team _ xiaosun

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

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

Depending on your timezone the datetime value balnk corresponds to 1899-12-31 or 1899-12-30. 

You can try to replace the blank with "null" in Power Query and publish it to the web again to see if the problem still remains.

 

Best Regards,
Community Support Team _ xiaosun

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