Disabling cache in Excel / PowerBI for OData

Question

In my project, I'm using Microsoft.AspNet.OData to create OData WebApi service.

I've noticed that all data returned from my OData WebApi service are cached inside Excel and/or PowerBI. I would like to avoid this situation. Ideally, I'd like to turn off caching for any data from my service.

Is there an easy way to achieve this? Any attribute, response header? In the past I have tried cache-control header but with no luck.

Answer 1

There is no way to disable cache. But the following works fine. After loading the data in powerbi or powerquery you need to follow the following steps

1: Go to File

2: Go to option and settings

3: Go to query options

4: Clear cache

This is the only way to do this, you and also reduce the cache to 5Mb. This might help upto some extent.