Excel oData always downloads a lot of metadata. How to disable

(0) Share

Report

Posted on by markmj

584

Hi All

On latest version of F&O.

I'm creating some Power Queries in Excel for some business users. Every single query is making a second call to /data/$metadata, so my query that returns 1 record with 3 columns is taking about 10 secs due to the 28MB meta data download

I also tried

How can I prevent this:

I've tried adding this to the query: &$format=application/json;odata.metadata=none, but i get this error

"The query table couldn't be refreshed:
[DataFormat.Error] OData: We were unable to detect required payload information."

(this does work in PostMan)

I also tried: &$format=application/json;odata=nometadata

Anyone know how to prevent this second call to /data/$metadata

thanks

mark

I have the same question (0)

All responses (1)

Answers (0)

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mark,

I do assume you are using OData for getting the records via Power Queries? If you are using standard entities to get the data, you can contact Microsoft Support.

Was this reply helpful? Yes No