Merge Queries - Refresh issue

[Wesleyvanv]

Hi All, I have performed a merge query on my salesshipment table. After the merge I have filtered on the items on which the merge was done. I have counted the rows and I have 6832 rows of these specific items. I would expect only these rows are imported, but when applying my changes the refresh is still loading my whole salesshipment table of more than 1M rows. Please find below my advanced editor statement. What have I done wrong? Thanks Wesle

[v-chuncz-msft · Accepted solution]

@Wesleyvanv 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Query-Folding-Documentation/m-p/359796#M162306