Currently, I am practicing my Power BI skills using the **latest Stack Overflow survey dataset**. In the dataset, multiple columns contain multi-select answers separated by semicolons. I need to extract this data for further analysis. I used the *'split columns into rows' technique*, which caused the number of rows to increase dramatically. Additionally, how can I structure my data model in Power BI in terms of fact and dimension tables?
Currently, when I try to split each column by its semicolon-separated values, I cannot load the dataset into Power BI, and the results are not correct. How can I deal with these columns? Should I separate them from the main fact table? What are the right steps to use these multi-select columns?
