Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
felipelf
New Member

Error when getting data from a SharePoint list in a LookUp Multi field

I am getting the data from a SharePoint list which has a LookUp Multi field and when I try to see what is inside the following error is displayed:

Captura.PNG

 

3 REPLIES 3
lbendlin
Super User
Super User

Good. Correct your query parameters and try again.

lbendlin
Super User
Super User

Do you get the same error when using an ODATA connection?

When I use an OData connection I get the following error:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The query to field 'ColTrabajadores' is not valid. The $select query string must specify the target fields and the $expand query string must contains ColTrabajadores.)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (The query to field 'ColTrabajadores' is not valid. The $select query string must specify the target fields and the $expand query string must contains ColTrabajadores.)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The query to field 'ColTrabajadores' is not valid. The $select query string must specify the target fields and the $expand query string must contains ColTrabajadores.)"

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.