This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I can insert a blank row using this code:
= Table.InsertRows(Source, 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})
but the zero inserts at the beginnng of the table.
I would like to insert the blank row at the last row.
I tried using Table.PositionOf(Source, RowAsRecord) but do not know how to extract the RowAsRecord.
Table.LastN(Source, 1) // locates the row, but is not a record type.
Finally I tried converting it to a record, but is not in the format [name="", value=""]
Record.FromTable(Table.LastN(Source, 1))
Hence, this code does not work:
= Table.InsertRows(Source,
Table.PositionOf(Source,
Record.FromTable(Table.LastN(Source, 1))),
{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})
Please advise. Thank you!
Solved! Go to Solution.
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate
Thank you @Anonymous that was easy!
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |