Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 date 12/30/1899.
You can see the differences in the images below:
Desktop:
Web:
The field in the table is classified as "date".
What am I doing wrong?
How do I guarantee that on the web the date keeps appearing "blank"?
Best regards.
Solved! Go to Solution.
Hi @bmms ,
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.
Hi @bmms ,
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.
Hello,
by default in the power query, the column is already filled with null!
Best regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |