OData Feed Keeps on Loading the Data Again and Again

[Gaurav_Lakhotia]

Hello Community Members,

I'm facing an issue with OData Feed connector. I'm using it to get data from D365 to Power BI. There are a few transformations done in the Query Editor. Earlier it was working fine but now when I try to apply the changes after removing a data transformation step(Filter Rows) it keeps on loading data again and again.

As in the image, it shows 84.7 MB but it will start loading from start.

Any suggestion please...

Thanks

[lbendlin]

Are you able to post a sanitized version of the relevant piece of your Power Query code?

[Gaurav_Lakhotia]

Hi @lbendlin, here is the M-code,

Thanks

[lbendlin · Accepted solution]

I would not sort my data in Power Query - it is not necessary.

I would also use Table.Buffer in the second step to load the data only once.

How important is SalesChannelMap.Name to you?  Is that something you could join in the data model rather than in a Power Query Merge (which is very expensive) ?