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
Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

stvcdms, It is identified as a known issue with SharePoint that the team is actively working to resolve. Will keep you updated once I get any updates. 

ShaneC's avatar
ShaneC
Frequent Visitor
10 years ago

Any further updates to this? It is a pretty common scenario and the fact that Microsoft is supporting the ability to allow Power BI to connect to a SharePoint Online list as a supported datasource, and it fails, is pretty crazy!

 

Out of the box it fails and you have to set the API version from 15 to 14 to to get something working.

 

Please help with this!

  • vanghjort's avatar
    vanghjort
    Regular Visitor
    10 years ago

    If I change the API version from 15 to 14, I still get an error:

     

    Expression.Error: The key didn't match any rows in the table.
    Details:
        Key=Record
        Table=Table

     

    Do some of you have a way to remove this error?

     

    Thx in advance