Forum Discussion

DolEgon22's avatar
DolEgon22
Icon for Advocate II rankAdvocate II
10 years ago

SharePoint list - missing data in columns

After some trial and error, I am finally able to connect Power BI Desktop to my SharePoint 2010 lists. However, there is a pretty major annoyance:   I have a SharePoint task list which includes som...
mmoizk's avatar
mmoizk
Icon for Helper III rankHelper III
10 years ago

Thanks Qiuyun Yu, I am getting an Error instead of table or list or record ? ANd what does the 2 outwards arrows signifies ? Nextt to the column Name 

ShaneC's avatar
ShaneC
Frequent Visitor
10 years ago

Somewhat related, but have you guys found a way to display the select Id's for a specific column that has "allow multiple selection" enabled?

 

In my scenario, I have a list with a lot of column, and a few columns have options for multiselect. These columnscome through as "Table" as shown above. For single select options, they come through as "Record".

 

One way to get the select value, is to "Expand" that column. This however has dramatic impact in performance. Has anoyone find a good way of managing Choice columnswith multiselect enabled?