Forum Discussion
Solved
blank dates causing issues in Power BI service
I have a datetime field with contains several blank records. In Power BI desktop these are shown as blank, and in Power BI service the same. However once the first refresh in Power BI service runs, ...
just to be clear, 0 and null are not the same thing. Depending on your timezone the datetime value 0 corresponds to 1899-12-31 or 1899-12-30. That's Microsoft's definition of when the epoch starts.
is it possible that your MySQL source is a bit cavalier in sometimes giving you 0 and sometimes null ?
I ran into something similar, and I would suggest replacing all with nulls in using M Query.
Add steps to replace the BLANKS and " 0 " values....or any value.....
or another more dynmaic way to go about mabe is:
if the %Value_Type% = "Date" then Value,
else if % Some Other Expression % then ........
else NULL