79290265

Date: 2024-12-18 07:26:31
Score: 2.5
Natty:
Report link

It's possible that Excel has cached the metadata model.

You'll notice at the top of your OData document there is a link to a metadata document.

Excel and Power BI will download and cache this document, even if the document clearly states "do not cache me" in its response headers.

Once cached, any new columns will cause Excel to get upset at a new column appearing in the data document.

In Excel: Data > Get Data > Query Options > Data Load > Data Cache Management Options > Clear Cache.

Reasons:
  • Blacklisted phrase (1): this document
  • No code block (0.5):
  • Low reputation (1):
Posted by: Mark Holst