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.