"No columns found" expanding a column whose source is a SharePoint List column with multiple choices

[hjasmin]

Hello,  Let me lay out this in a simple way.

  I have a sharepoint list. It contains a column that supports multiple selections. 

I need to build a report in Power BI.

I am not doing " Power BI integration", I need to combine multiple lists, so started a fresh copy of report. 

During data formatting stage, I am not able to expand the multi-select column into multiple rows. 

The data shows up as Table data type. 

However, I did expand two columns that are of PEOPLE type at sharepoint side. And they were single select columns. 

How can I expand a multi-select column from sharepoint, via power bi. 

Thanks

[hjasmin · Accepted solution]

Found a workaround. 

Swtiched the API version from 15 to 14 in advanced editor.