Forum Discussion

coreyw's avatar
coreyw
Helper I
10 years ago
Solved

Power BI Desktop - does it cache OData V4 metadata?

Hi There.

 

I'm using Power BI against an OData V4 source I'm currently developing so the data source metadata is changing regularly. I've noticed that I've been bitten a few times by Power BI 'remembering' property names that no longer exist.

 

When I look at the data source metadata via a browser against the OData service itself, I see all the proper properties and navigation properties. But in Power BI, when I specify the same OData service resource (via 'Get Data'), pick an entity, when it goes into Power BI query editor it's referencing 'old' properties that no longer exist - hence Power BI blows up.

 

So it looks like the old metadata is being held on somehow. Is there anyway to reset what appears to be cached metadata?

Thanks!

Need Help
  • JvdW's avatar
    JvdW
    10 years ago

    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!

3 Replies

  • JvdW's avatar
    JvdW
    Advocate I
    10 years ago

    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!

    • medihasiljic's avatar
      medihasiljic
      Helper I
      9 years ago

      This doesn't seem to work anymore, tried it many times.

       

      Anyone's got better idea, because I'm stuck :)

    • medihasiljic's avatar
      medihasiljic
      Helper I
      9 years ago

      Hi,

       

      This doesn't seem to work anymore. Anyone figured out a different way to refresh data structure from OData feed?

       

      :)