Forum Discussion

GFinlayTerumo's avatar
GFinlayTerumo
Frequent Visitor
1 year ago
Solved

OData feed expand does not display results

Hi   I have an OData feed coming from a Mendix application which I am consuming in PBI.  In order to try and cut down on the load / query times in the refresh I am trying to do my filtering on the ...
Need Help
  • GFinlayTerumo's avatar
    GFinlayTerumo
    1 year ago

    Hi lbendlin rohit1991 

     

    I was able to resolve this issue by adding Table.ExpandRecordColumn to the start of my Source query and including the associated table within the OData Select statement.  Screenshot below with multiple nested Table.ExpandRecordColumn statements.

     

     

    Thanks

    Grant

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Make sure that your OData service supports V4, and that "Name"  is the actual field name. You could also manually expand that record and then use Query Diagnostics to see what the actual OData call looks like

 

In older versions you can do 

 

Example :

https://services.odata.org/V2/Northwind/Northwind.svc/Categories?$expand=Products&$select=Products/ProductName

  • GFinlayTerumo's avatar
    GFinlayTerumo
    Frequent Visitor
    1 year ago

    Hi lbendlin rohit1991 

     

    I was able to resolve this issue by adding Table.ExpandRecordColumn to the start of my Source query and including the associated table within the OData Select statement.  Screenshot below with multiple nested Table.ExpandRecordColumn statements.

     

     

    Thanks

    Grant