Kadu on 04 Oct 2016 20:41:37
When a Sharepoint field with multiple values lookup is expanded, I receive the following response: DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (Specified method is not supported.)
- Comments (5)
RE: Support to Sharepoint Lists having lookup fields with multiple values
I am getting this as well
RE: Support to Sharepoint Lists having lookup fields with multiple values
It appears that PowerBi can lookup list data (choice fields) however cannot lookup multiples values where column is a "Lookup" or "People" column.
Large of reporting use cases enabled if this is resolved.
RE: Support to Sharepoint Lists having lookup fields with multiple values
I'm using PowerBI against some lists in SharePoint Online. I don't get the error you mentioned, but instead i get 2 options (after data load) on how to handle the lookup column: 1) Merge ... which combines the selected values and puts them in a text field and delimits the values with a delineator you can choose, and 2) create a new record in the datamodel table for each selected value in the multi-select. (When I tried #2, it gave an error when reloading data indicating that I had multiple items with the same value in a unique field. So I'm not there yet, but thought I'd share what I've discovered so far.
RE: Support to Sharepoint Lists having lookup fields with multiple values
Also have this issue - need it resolved
RE: Support to Sharepoint Lists having lookup fields with multiple values
I do have this issue. Were you able to resolve it?