Forum Discussion
Multiple choice column from SharePoint Lists
Hi. I am using a SharePoint List from Office 365 as a data source. One column I created in this list is a multiple choice one. The problem is that when I pull the data from the SharePoint List, the r...
Greg_Deckler
Community Champion
Community ChampionSee those little arrows pointing in opposite directions in your column? Click on that button and expand your Table in order to get the value.
I am trying to test Power BI analysis over a SharePoint list, and my fields also allow multiple responses (from a seperate sub list).
When I query the primary table, the fields return ' [list] ' in every row regardless of what is in the actual list. How do I relate this back to the sub-list tables, or expose the responses?
ID.1 | RoleID |
9 | [List] |
5 | [List] |
6 | [List] |
8 | [List] |