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
ThoSch's avatar
ThoSch
Regular Visitor
9 years ago

same here:

 

i try this:

let
    Source = SharePoint.Tables("https://YourSharePointServerHere.com", [ApiVersion = 14]),
    List = Source{[Name="YourListNameHere"]}[Content]
in
    List

an get this error:

 

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

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Changing to [ApiVersion = 14] in Source fixed my problem with the SharePoint List column names not updating to the current column SharePoint title when pulling the list into power Bi. Microsoft should fix this for 15!

 

The problem "Expression.Error:" went away for me if you rebuild the applied steps  in the query editor after the Navigation (default name) step. (Note:  in ThoSch's code step was called List.)