Forum Discussion
Solved
Load only filtered rows in Power Query
I have a source excel table on which I use Power Query to get a desired excel table (say Table1). Now further I want to run a Power Query on Table1 based on the filtered rows only (which I want t...
Power Query itself doesn't recognise is row filtered or not. You may add helper column to the source table, e.g. named as IsHidden with formula like
=AGGREGATE(3,5,[@AnyField])IsHidden returns zero for hidden rows and 1 otherwise. Power Query could be filtered based on that field.
Power Query itself doesn't recognise is row filtered or not. You may add helper column to the source table, e.g. named as IsHidden with formula like
=AGGREGATE(3,5,[@AnyField])IsHidden returns zero for hidden rows and 1 otherwise. Power Query could be filtered based on that field.