This used to work, with newer updates I'm not able to load dates that are missing in some records. Seems like Power BI needs to have all dates if a date/time data type is used. Text data type works f...
Figured out I had a character of "-" so I just did a replace value and left the replace with empty which resolved my issue
