Forum Discussion

stvcdms's avatar
stvcdms
Frequent Visitor
10 years ago

Power Query SharePoint List Error with Allow Multiple Selection on People or Group Field

Hello,   I noticed today that if I am trying to connect to a SharePoint list and that list has a People or Group field with the allow multiple selection option enabled, that it causes a null value ...
Need Help
bmcilquham's avatar
bmcilquham
New Member
8 years ago

Is there any update to this?

If I was to use the OData fix, I don't get columns "Managed Metadata" column types returned.  If I change the "[ApiVersion = 15]" from 15 to 14 it switches me back to SP2010 which doesn't allow me access to "Managed Metadata" column types either.  Setting certain columns to not be null or not multi-select is not an option.

 

Environment:

  • SP2013
  • Power BI Desktop version 2.56.5023.942 64-bit (March 2018)