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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi GFinlayTerumo,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you want to optimise the time taking to query at refresh. As rohit1991 and lbendlin both already responded to your query, please go through the responses and mark the helpful reply as solution.

 

I would also take a moment to thank rohit1991 and lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.