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

[Syndicate_Admin]

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 "integration", I need to combine multiple lists, so started a fresh copy. 

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

[Syndicate_Admin]

Which API version do we need to switch to 

[Syndicate_Admin · Accepted solution]

Found a workaround. 

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