Forum Discussion

Xaraja's avatar
Xaraja
Helper III
4 years ago
Solved

Null Values Date Data Type

I am working on a dataset I inherited and I am seeing an issue that I don't know exactly how to fix. The underlying SQL table is a list of warehouse events (picking, packing, etc), and there is a col...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Xaraja 

     

    Power BI can accept null or blank values in a date data type column. In Power Query Editor, it displays null. In Power BI Desktop, it displays blank. In below image, it shows the same table in two places. 

     

    What is the error message do you see? If the report is working, perhaps the cause is not the null values in date columns. Can you please show the error message after removing sensitive info? 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Xaraja 

 

Power BI can accept null or blank values in a date data type column. In Power Query Editor, it displays null. In Power BI Desktop, it displays blank. In below image, it shows the same table in two places. 

 

What is the error message do you see? If the report is working, perhaps the cause is not the null values in date columns. Can you please show the error message after removing sensitive info? 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

ShinyIon's avatar
ShinyIon
Helper I
2 years ago

Power bi does not accept null date values in table visual. I just tested it with and without nulls and it fails on nulls.