When using oData with Excel, a considerable amount meta data is being returned (as a separate response). For example, querying for one product returns 799 bytes of result data (1 record with 2 columns) and about 28MB of metadata, which makes the excel refresh take WAY too long.

If I use Postman to send exactly the same query, this does not happen. Further, even if I remove the &$format=application/json;odata.metadata=none from the Postman query, the response size only goes up to 806 bytes

This makes oData almost useless when using power query