cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Re: How to Remove Error in Date Field

am getting this error as well. power bi does not put null for blank cells if we format the column as date. is there a way to work around this?

Highlighted
Anonymous
Not applicable

Re: How to Remove Error in Date Field

Did you ever figure this out?  I am running into the same issue with needing blank cells in a date field.  It errors out when I convert to a date.

Highlighted
Solution Specialist
Solution Specialist

Re: How to Remove Error in Date Field

I am still not able to replicate the issue...  When I have dates formatted as text and then converted to a date, all blank cells are shown as "null" rather than errors.  I even tried adding spaces instead of having truly blank cells, but the query editor handled it in the same way.  Is there some test data that you can share to help duplicate the issue?

Highlighted
Anonymous
Not applicable

Re: How to Remove Error in Date Field

I finally figured out my issue.  I thought it was brining in blanks when I looked at the data but it was actually bringing in "Unknown".  I converted the "Unknown" to "null" and then changed the type to "date" and it worked.  Support was able to help me with this.  I believe I was looking at the data after I tried converting to a date instead of prior (which is why I saw blank instead of unknown) AND I forgot to "load more.." results to see in the drop down for the column what it was bringing in besides dates prior to trying to convert to a date.

Highlighted
Frequent Visitor

Re: How to Remove Error in Date Field

It actually just let me right-click in the power query and select replace errors and I typed 'null' and it worked

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors