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, Table.FirstN appears to do nothing, with all 4 rows still appearing in the preview, as shown in the screenshot below:
This persists through refreshing the data, closing and opening the dataflow, and in other queries in the same dataflow that reference this one.
When loading the externally (e.g. Excel, Power BI, other Dataflows), the correct number of rows does appear, so it seems like it's a bug with the Dataflows preview, rather than Power Query itself.
2 Comments
Hi Ceeeg
You mentioned that the query worked in other Dataflows , did you compare the differences between these two dataflows ? How did you create a dataflow(preview) ?
Best Regards,
Community Support Team _ Ailsa Tao
CeeegAdvocate I
Anonymous
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.
