Column from SharePoint List as Data Source Shows as Blank

[newgirl]

Hello!

My data source is a SharePoint List and I noticed there is a column that's blank when looking at it from Data View but when checking the same item in the list itself, there's actually values inside.

For the other items with only one value, it shows up but how can I have the cell with multiple values show?

Item with one value (which shows up):

Item with multiple values (does not show up):

[v-easonf-msft · Accepted solution]

Hi, @newgirl 

For Multi-Value Fields in sharepoint, you need to expand the list and select comma as delimiter to extract the values in Query Editor.

For detailed steps, you can refer to these related tutorials.
Using Power BI to Report on Multi-Value SharePoint Fields 
Reporting Using Multi-Value Fields in Power BI 

Best Regards,
Community Support Team _ Eason