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

you should be able to run the same query as in the query diagnostics, and get the same result. If you don't get that then maybe you should raise a ticket.

GFinlayTerumo's avatar
GFinlayTerumo
Frequent Visitor
1 year ago

Hi

 

Thanks the query diagnostics shows me that it loads successfully but doesn't give me any info about what it is outputting etc.  I will put in a ticket and if I get a resolution I will post a reply so as to close the post.