Duplication of Records from OData source

[TBensen]

Hello,

I'm having an issue with one of my OData data sources duplicating records.  I created a whole new report and imported this OData connection to see if it was something in my previous report that was causing this, but it still doing the same thing.

Here is snippet of data that is showing the cuplicate records.  The information contained in all of the columns in the data source are the same except for the "RowNum".  I don't have any other "Applied Steps" besides the Source and Navigation ones.

You can see the duplicates in Record No 6241, 6233, 6222, 6206, and 6199.

Another thing I have noticed, is there are missing records in the Power BI data source that are present in the original data source, so if I remove duplicates from the Record No column, I get a misrepresentation of the data.

I have also noticed this error when I click on a row in the Power Query Editor.

I'm not sure if the error is related to the issues I'm having, but I don't really know where to start with this issue.

Thank You,
Trevor Bensen

[TBensen · Accepted solution]

The issue stemmed from the application's data source.  There was a feature enabled on the platform that pagniated the data.  By turning this feature off, the issue has been resolved.

Thanks,

Trevor Bensen

[mariaroche]

Hi! Odata is the connector so, what is the source of the data here? any platform? Also, what kind of settings might i need to change if the data is streaming in from D365?