Forum Discussion

iDataDrew's avatar
iDataDrew
Advocate IV
8 years ago

Current state OData instance being preserved upon refresh?

I'm working with current state project data from an OData feed.  So there should only be one row per project.  However, after refreshing the data several times over a few weeks, some projects have mu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi iDataDrew,

 

Have you checked on your source data? If your source contains same date records or duplicate records, it will return multiple rows.

In addition, if odata url conversion not work, you can also add current date filter in power query.

 

Regards,

Xiaoxin Sheng

  • iDataDrew's avatar
    iDataDrew
    Advocate IV
    8 years ago

    Anonymous, thanks for the response.  I've been told that the source data is only showing one row for each project.  Could you explain further what you have in mind with the OData url conversion?  The data contains dates in it, such as start date, end date, baseline dates, etc., but it doesn't contain an actual date field, like today's date.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi iDataDrew,

       

      >>Could you explain further what you have in mind with the OData url conversion? 

      It is a typo, in fact, I mean 'url conventions'.

       

      For url conventions, you can check at below link:

      URL Conventions (OData Version 3.0)

       

       

      Regards,
      Xiaoxin Sheng