Question: how to convert yyyymmdd to date in power bi?
Answer: just make the yyyymmdd column a text column.
make the text column from step 1 a date column (when prompted, be sure to select 'Add New Step')
replace errors with null.