79414738

Date: 2025-02-05 12:30:59
Score: 1
Natty:
Report link

I do not understand why Item keep a compact format.

Using expand function on an OData endpoint doesn't mean it will return a flat table.

It means that you are requesting related data, that are not by default provided in the response. Expand function can be used for complex types and collections.

How should I proceed to do so?

By the image, I guess, you are working in Power Query which offers JSON and XML parsing functionality. I would suggest following Parse text as JSON or XML (Power Query).

Reasons:
  • Blacklisted phrase (1): How should I
  • No code block (0.5):
  • Contains question mark (0.5):
  • High reputation (-1):
Posted by: petesramek