Hello, I am importing data with multiple response column to MS Power BI through ODATA. When imported, the multiple response column is presented as a column with multiple answers delimited with space. How do I set up the import such that each answer in the multiple response question will be split as multiple columns? This is the same as checking the "Split “select multiple” choices into columns" when downloading via CSV. Thank you.
@dmpm, Based on my knowledge, I think there isn't an option to apply such settings when importing data via ODATA, unlike when downloading through CSV, where this feature is available.
The viable approach, as you're likely aware, is to perform the data transformation in Power BI using Power Query to split the multiple response column(s).
Best regards.
1 Like