Forum Discussion
Helper IPower BI Desktop - does it cache OData V4 metadata?
I've been struggling with this issue for a few hours trying to consume Dynamics NAV 2016 objects on a local instance. It looks like Power BI does cache data for OData feeds. The following worked for me:
1. In Power BI desktop: specify the same OData URL via "Get Data". When the query editor is opened go to "Start" in the ribbon. Click "Refresh Preview". After this PowerBI should refresh the OData feed and remove old data or add new data.
2. In Power BI desktop: go to "File" in the ribbon. Open "Options". Under "Data Load" you have the option to clear cache. When you specifiy the same OData URL after doing this, the OData feed should return the correct data.
Quite simple but it worked for me!
Advocate II've been struggling with this issue for a few hours trying to consume Dynamics NAV 2016 objects on a local instance. It looks like Power BI does cache data for OData feeds. The following worked for me:
1. In Power BI desktop: specify the same OData URL via "Get Data". When the query editor is opened go to "Start" in the ribbon. Click "Refresh Preview". After this PowerBI should refresh the OData feed and remove old data or add new data.
2. In Power BI desktop: go to "File" in the ribbon. Open "Options". Under "Data Load" you have the option to clear cache. When you specifiy the same OData URL after doing this, the OData feed should return the correct data.
Quite simple but it worked for me!
medihasiljicThis doesn't seem to work anymore, tried it many times.
Anyone's got better idea, because I'm stuck :)
- medihasiljic
Hi,
This doesn't seem to work anymore. Anyone figured out a different way to refresh data structure from OData feed?
:)