Is it possible to pad a table with empty rows?

[WhitmarkEA]

I have a dataset (SharePoint list) which self-builds over time via user input and Power Automate flows.  I currently bring the SP list into Power BI and perform some steps and cleansing in Power Query before visualising in Power BI.

I am in a position where once a month, I need the table to be padded with a numer of blank rows, for downstream processing.

i.e. Currently, every month I export a copy of the table for use in another piece of software - which expects a table with specific dimentions.

Is it possible to pad a table to a specific number of rows, with the target number of rows coming from another table in the report (i.e. it's already loaded into Power Query)?

[slorin · Accepted solution]

Hi,

if you want 1000 rows

= YourSource & Table.FromList(List.Repeat({null},1000-Table.RowCount(YourSource))) 

 Stéphane