Power Query to Report refresh loading more data?

[reubenusher]

Hi,

Hopefully someone can help.

I have a report with unique Works Order Numbers which I have skimmed down to display any >700,000, on top of this I have filtered out elsewhere and now I am left with my smallest Works Order No. to be 708793 and my largest to be 756138 meaning that at the most I should have 47345 rows of data, however when I try to apply the changes and go from Power Query to Report View / or when refreshing the report, I can see that my Works Order data is loading around 1,000,000 rows. 

Is there any reason behind this?

[Anonymous · Accepted solution]

Hi @reubenusher ,
Based on your description and the screenshot provided, first of all, while you have filtered out unique work order numbers greater than 700,000, there may still be other duplicates in the dataset that have not been properly filtered out. You can use the Remove Duplicate Items feature to accomplish this.
Second, if there are other filtering or join operations in your Power Query that are not being considered, they may be introducing additional rows.
Then, sometimes, conversion steps such as expanding columns, merging queries, or adding custom columns may inadvertently increase the number of rows.
Finally, Power Query may keep the original dataset and then apply your filters on the original dataset, causing the entire dataset to be loaded into the report before the filters are applied. So make sure that your filter is one of the last few steps in the Power Query editor and that you are not loading unnecessary report data.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly