Hi, I've made a simple query in a Dataflow, which appends 4 single row/single column tables (linked), sorts them, and then using Table.FirstN returns the first two rows. In the preview result...
Ceeeg
Advocate I
Advocate IAnonymous
When I said it worked in other Dataflows, I meant that when I was in a separate Dataflow and referenced the Dataflow that had the Table.FirstN, it loaded in two rows, as I would expect the result to be from the query.
When I said about the Dataflow Preview, I was meaning the preview results that you see in the query editor.
So what I was meaning to say is that the actual results are fine, and can be used elsewhere without issue, it's just that the preview results that I see in the query editor show all rows, as though the Table.FirstN hasn't been applied.