Solved: Merge Queries - Refresh issue

Wesleyvanv · ‎09-17-2019

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 · ‎09-17-2019

@Wesleyvanv

You may take a look at the post below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎09-17-2019

@Wesleyvanv

You may take a look at the post below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.